Is cycle references? - Mailing list pgsql-general

From
Subject Is cycle references?
Date
Msg-id Pine.LNX.4.10.10011011151070.5554-100000@www.pumpkinnet.com
Whole thread Raw
Responses Re: Is cycle references?  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: Is cycle references?  (Tod McQuillin <devin@spamcop.net>)
List pgsql-general
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?

We appreicate your hints.

Limin
pumpkin networks


pgsql-general by date:

Previous
From: Chris Jones
Date:
Subject: database synchronization
Next
From: "Steve Wolfe"
Date:
Subject: DBI -> remote host?