From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
---|---|
To: | limin(at)www(dot)pumpkinnet(dot)com |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Is cycle references? |
Date: | 2000-11-01 21:35:58 |
Message-ID: | Pine.BSF.4.10.10011011335330.71136-100000@megazone23.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, 1 Nov 2000 limin(at)www(dot)pumpkinnet(dot)com wrote:
>
> The db schema we have need to do a cycle references. I.e.,
> an attribute in table_1 references the key in table_2 and
> an attribute in table_2 references the key in table_1. However,
> PostgreSQL does not allow us to make reference to an "non-existing" table!
> If we create a fake table_2 first, then create table_1, drop table_2,
> create the "real" table_2, we will lost the reference constraint during
> droping the "fake" table_2.
>
> Is there any work-around on this issue?
Use ALTER TABLE ADD CONSTRAINT to add the constraint after
the second table is made.
From | Date | Subject | |
---|---|---|---|
Next Message | Edmar Wiggers | 2000-11-01 21:52:13 | pgsql-general Digest |
Previous Message | Steve Wolfe | 2000-11-01 21:33:26 | Re: DBI -> remote host? |