> > I am pretty sure that pg_dump produces a consistent snapshot, using
> > the same transaction isolation mechanism (MVCC) as the database
> > itself. If one of the gurus posts and says otherwise, believe him,
> > not me. ;)
>
> My impression from reading the source was that it was consitant per-table
> but not per-database. Meaning you'd get a consistant snapshot of a table,
> but not of the entire system.
>
> I could be wrong though.
I hope so... that could break some foreign key dependencies pretty badly...
Greg