Re: PG_DUMP and table locking in PG7.4

Поиск
Список
Период
Сортировка
От Yann Michel
Тема Re: PG_DUMP and table locking in PG7.4
Дата
Msg-id 20051116030920.GA6014@zoom.spline.inf.fu-berlin.de
обсуждение исходный текст
Ответ на Re: PG_DUMP and table locking in PG7.4  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Ответы Re: PG_DUMP and table locking in PG7.4  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Список pgsql-hackers
Hi,

On Wed, Nov 16, 2005 at 09:59:44AM +0800, Christopher Kings-Lynne wrote:
> It acquires share locks on EVERY table.

do you mean on EVERY inherited table once one of them is dumped? Or do
you mean that a share lock is requested(and hold) on each of them once
one is dumped, i.e., sequentially?

Thanks,
Yann


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Douglas McNaught
Дата:
Сообщение: Re: bind variables, soft vs hard parse
Следующее
От: Andrew - Supernews
Дата:
Сообщение: Re: PG_DUMP and table locking in PG7.4