Is something like the following allowed (or is not a Bad Idea)?
table1
---------+-------------------------
id1 |serial primary key
col2 |int references table2(id2)
table2
---------+-------------------------
id2 |serial primary key
col2 |int references table1(id1)
Obviously, creating the tables is a problem since the constraints require
that the other table exists.
If doing the above is *not* a Bad Idea, how could I work around this
problem?
(That is, (how) can I add the constraints after table creation?
I imagine something with "create constraint trigger", but the manual is
not very clear on that.)
Thanks
dan
