Craig Ringer <[EMAIL PROTECTED]> 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
Craig Ringer wrote:
Hi all
I'm running into an issue with my schema where I'm trying to establish a
mandatory two-way relationship between two entities, and I'm hoping for
some external wisdom. Using "customer" and "address" by way of example:
CREATE TABLE customer (
id INTEGER PRIMARY KEY,
a
Hi all
I'm running into an issue with my schema where I'm trying to establish a
mandatory two-way relationship between two entities, and I'm hoping for
some external wisdom. Using "customer" and "address" by way of example:
CREATE TABLE customer (
id INTEGER PRIMARY KEY,
address_id INTEGER NOT
