Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Tue, 25 Mar 2008 11:07:38 -0400
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
- References:
- Deferrable NOT NULL REFERENCES ... for two-way referential relationship
- From: Craig Ringer
- Deferrable NOT NULL REFERENCES ... for two-way referential relationship
- Prev by Date: Re: Deferrable NOT NULL REFERENCES ... for two-way referential relationship (SOLVED?)
- Next by Date: copy command and array of composite types?
- Previous by thread: Re: Deferrable NOT NULL REFERENCES ... for two-way referential relationship (SOLVED?)
- Next by thread: copy command and array of composite types?
- Indexes: