Re: deferred check constraints - Mailing list pgsql-general

From Gregory Stark
Subject Re: deferred check constraints
Date
Msg-id 87hco4vz18.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: deferred check constraints  (Perry Smith <pedz@easesoftware.com>)
List pgsql-general
"Perry Smith" <pedz@easesoftware.com> writes:

> I need to add an element to table A and an element to table B that reference
> each other.  The "polymorphic" gunk comes up because table  B is not the same
> table each time.

Not that I haven't done similar things in the past but you should think hard
about whether you can't normalize your data further to avoid this. It will
make querying your data later much easier. (Think of what your joins are going
to look like.)

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com


pgsql-general by date:

Previous
From: Chris Browne
Date:
Subject: Re: SMTP
Next
From: "Sébastien Boutté"
Date:
Subject: Re: pg_dump without blobs