| From: | Gregory Stark <stark(at)enterprisedb(dot)com> |
|---|---|
| To: | "Perry Smith" <pedz(at)easesoftware(dot)com> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: deferred check constraints |
| Date: | 2007-07-16 21:06:43 |
| Message-ID: | 87hco4vz18.fsf@oxford.xeocode.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Perry Smith" <pedz(at)easesoftware(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sébastien Boutté | 2007-07-16 21:13:33 | Re: pg_dump without blobs |
| Previous Message | Jasbinder Singh Bali | 2007-07-16 20:55:18 | Capturing return value of a function |