Re: AW: Proposal: More flexible backup/restore via pg_dump

> I don't suppose anyone knows of a way of telling if a file handle supports
> seek?

The traditional method is to call lseek() and see what happens.

> Part of the motivation for this utility was to allow DBAs to fix the
> ordering at restore time, but otherwise I totally agree. Unfortunately I
> don't think the RI checks can be delayed at this stage - can they? 

The current pg_dump handles the data and then adds the constraints.

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.

Regards,

Giles