PG_DUMP and table locking in PG7.4

From: Yann Michel <yann-postgresql(at)spline(dot)de>
To: pgsql-hackers(at)postgresql(dot)org
Subject: PG_DUMP and table locking in PG7.4
Date: 2005-11-13 02:22:23
Message-ID: 20051113022223.GA11636@zoom.spline.inf.fu-berlin.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I'm using PG_DUMP for backing up a postgres 7.4 database. As I have
seen, the pg_dump aquires a table lock while dump the table's content.
What will happen, if I have a basic table and several inherited tables.
Will the PG_DUMP tool only aquire locks on the inherited tables or on
the parent-table, too?

Thanks in advance!

Cheers,
Yann

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Samer Abukhait 2005-11-13 05:01:29 Re: CONNECT BY PRIOR
Previous Message Yann Michel 2005-11-13 02:05:26 Re: CONNECT BY PRIOR