On Wed, 1 Nov 2000 limin@www.pumpkinnet.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.