Re: Potential bug in pg_dump ... - Mailing list pgsql-hackers

From Brent Verner
Subject Re: Potential bug in pg_dump ...
Date
Msg-id 20020112021004.GA16489@rcfile.org
Whole thread Raw
In response to Re: Potential bug in pg_dump ...  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
[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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Potential bug in pg_dump ...
Next
From: mlw
Date:
Subject: checkpoint hang in 7.2b4