Re: Deferrable NOT NULL REFERENCES ... for two-way referential relationship

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Deferrable NOT NULL REFERENCES ... for two-way referential relationship
Date: 2008-03-25 15:07:38
Message-ID: 20511.1206457658@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Craig Ringer <craig(at)postnewspapers(dot)com(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jon Norman 2008-03-25 18:19:41 copy command and array of composite types?
Previous Message Craig Ringer 2008-03-25 13:56:44 Re: Deferrable NOT NULL REFERENCES ... for two-way referential relationship (SOLVED?)