> At 08:48 28/06/00 +1000, Giles Lean wrote:
> >Otherwise there are "chicken and egg" problems where two tables have
> >mutual RI constraints. Even at the tuple level two tuples can be
> >mutually dependent.
>
> Absolutely. And AFAICT, these happen with pg_dump.
This will happen for check constraints, but not for foreign key
constraints...
It actually adds the fk constraints later with CREATE CONSTRAINT TRIGGER
after the data dump is finished. And, if you do separate schema and data
dumps, the wierd statements at the top and bottom of the data dump turn
off triggers and then turn them on again (in the most painful way possible).
However those cases do not actually guarantee the validity of the data in
between.
