Postgres Pro
Downloads
Home   >   mailing lists

Re: PG_DUMP and table locking in PG7.4 - Mailing list pgsql-hackers

From Yann Michel
Subject Re: PG_DUMP and table locking in PG7.4
Date
Msg-id 20051116030920.GA6014@zoom.spline.inf.fu-berlin.de
Whole thread Raw
In response to Re: PG_DUMP and table locking in PG7.4  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Responses Re: PG_DUMP and table locking in PG7.4  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-hackers
Tree view 
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 by date:

Previous
From: Douglas McNaught
Date:
Subject: Re: bind variables, soft vs hard parse
Next
From: Andrew - Supernews
Date:
Subject: Re: PG_DUMP and table locking in PG7.4