Re: [BUGS] pg_dump and truncate

2007-02-22 Thread Feng Chen
ent: Thursday, February 22, 2007 2:28 AM To: Feng Chen Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] pg_dump and truncate "Feng Chen" <[EMAIL PROTECTED]> writes: > I was trying to do a live db archive using the following steps: > 1.Open a connection to the database; >

Re: [BUGS] pg_dump and truncate

2007-02-21 Thread Tom Lane
"Feng Chen" <[EMAIL PROTECTED]> writes: > I was trying to do a live db archive using the following steps: > 1.Open a connection to the database; > 2.With the connection, do the following: > BEGIN; > SET transaction ISOLATION level SERIALIZABLE; > 3.Execute the following from the Linux