X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 7E5DA9FC467 for ; Sun, 27 Aug 2006 04:20:04 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 65527-03 for ; Sun, 27 Aug 2006 07:20:01 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web31810.mail.mud.yahoo.com (web31810.mail.mud.yahoo.com [68.142.207.73]) by postgresql.org (Postfix) with SMTP id 8CE139FC464 for ; Sun, 27 Aug 2006 04:20:00 -0300 (ADT) Received: (qmail 57222 invoked by uid 60001); 27 Aug 2006 07:19:59 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=4kJRaK1ae4xZtQO7Frf1XSNTjRMDwn1jn1WJpxTuKdtkIpBLePxidRgeVNymiUDWYo3yvrKPawRbFbQTu63z1Dx9sD7rp1h5O6GyLpj29mieKMD96g72IlOaiUGshu1kB/qssPxXUEp8mCyquwurrTOvYGm7EcGDqA7YojJx7ko= ; Message-ID: <20060827071959.57220.qmail@web31810.mail.mud.yahoo.com> Received: from [24.54.196.198] by web31810.mail.mud.yahoo.com via HTTP; Sun, 27 Aug 2006 00:19:59 PDT Date: Sun, 27 Aug 2006 00:19:59 -0700 (PDT) From: Richard Broersma Jr Subject: Create Assertion -- Question from a newbie To: SQL Postgresql List MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.355 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS X-Spam-Level: *** X-Archive-Number: 200608/206 X-Sequence-Number: 26164 Sorry if my question is a little off topic. I am reading my new "SQL for Smarties" book side by side with the PostgreSQL 8.1 manual. I noticed that this particular feature is not included in PostgreSQL. Some of the achieve threads mostly discuss that this feature is currently not supported. My understanding is that Assertions place constraints upon data spanning multiple related tables. Is the Assertion feature slated to be added in the future? (Perhaps rolled up in a more generalized "TO-DO" item?) Would this feature add functionality that can not be achieved by other means? (i.e. alternative schema definitions or triggers?) Or does it merely provide a redundant means to constrain data, and thereby not warrant addition into the features of PostgreSQL? Regards, Richard Broersma Jr.