From: Bruno Wolff III <bruno@wolff.to>
To: Richard Broersma Jr <rabroersma@yahoo.com>
Cc: SQL Postgresql List <pgsql-sql@postgresql.org>
Subject: Re: Create Assertion -- Question from a newbie
Date: Sun, 27 Aug 2006 08:54:37 -0500
Message-ID: <20060827135437.GA1869@wolff.to> (raw)
In-Reply-To: <20060827071959.57220.qmail@web31810.mail.mud.yahoo.com>
References: <20060827071959.57220.qmail@web31810.mail.mud.yahoo.com>
On Sun, Aug 27, 2006 at 00:19:59 -0700,
Richard Broersma Jr <rabroersma@yahoo.com> wrote:
> 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?
You can accomplish what assertions do using triggers.
I think the issue is generating triggers for general assertions that don't
totally suck performancewise.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: bruno@wolff.to, rabroersma@yahoo.com
Subject: Re: Create Assertion -- Question from a newbie
In-Reply-To: <20060827135437.GA1869@wolff.to>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox