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