Re: Deferrable NOT NULL REFERENCES ... for two-way referential relationship - Mailing list pgsql-sql

From Tom Lane
Subject Re: Deferrable NOT NULL REFERENCES ... for two-way referential relationship
Date
Msg-id 20511.1206457658@sss.pgh.pa.us
Whole thread Raw
In response to Deferrable NOT NULL REFERENCES ... for two-way referential relationship  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-sql
Craig Ringer <craig@postnewspapers.com.au> writes:
> There are constraint triggers:
> http://www.postgresql.org/docs/8.3/static/sql-createconstraint.html
> and I could use one to enforce the NOT NULL on the table as a whole (at
> an acceptable cost in this case). However, I've seen some posts like
> this one:
> http://archives.postgresql.org/pgsql-hackers/2005-01/msg00882.php
> that suggest that constraint triggers are or have been deprecated.
> However, their removal is no longer on the TODO as far as I can tell.

Yeah, there is no longer any thought of removing them.
        regards, tom lane


pgsql-sql by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Deferrable NOT NULL REFERENCES ... for two-way referential relationship (SOLVED?)
Next
From: "Jon Norman"
Date:
Subject: copy command and array of composite types?