Re: Consistent pg_dump's

> > 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