Re: Potential bug in pg_dump ...

[2002-01-11 18:30] Tom Lane said:
| Brent Verner <brent@rcfile.org> writes:
| > Attached is a patch that implements table locking for pg_dump.
| 
| Checked and applied, with some small tweaking.  I broke the outer loop
| of getTables() into two loops, one that extracts data from the pg_class
| SELECT result and locks the target tables, and a second one that does
| the rest of the stuff that that routine does.  This is to minimize the
| time window between doing the pg_class SELECT and locking the tables.

ACK.  Now I understand what you meant by the "more than zero time"
to lock the tables :-)

thanks. brent

-- 
"Develop your talent, man, and leave the world something. Records are 
really gifts from people. To think that an artist would love you enough
to share his music with anyone is a beautiful thing."  -- Duane Allman