Re: Potential bug in pg_dump ...

Поиск
Список
Период
Сортировка
От Brent Verner
Тема Re: Potential bug in pg_dump ...
Дата
Msg-id 20020112021004.GA16489@rcfile.org
обсуждение исходный текст
Ответ на Re: Potential bug in pg_dump ...  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Potential bug in pg_dump ...
Следующее
От: mlw
Дата:
Сообщение: checkpoint hang in 7.2b4