> > 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...
In response to
pgsql-general by date
|Next:||From: Gregory Wood||Date: 2001-03-30 05:27:39|
|Subject: Re: function to operate on same fields, different records?|
|Previous:||From: Gregory Wood||Date: 2001-03-30 05:23:03|
|Subject: Re: database dirs very stange on solaris|