Postgres Pro
Downloads
Home   >   mailing lists

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

From Yann Michel
Subject PG_DUMP and table locking in PG7.4
Date
Msg-id 20051113022223.GA11636@zoom.spline.inf.fu-berlin.de
Whole thread Raw
Responses Re: PG_DUMP and table locking in PG7.4  (Yann Michel <yann-postgresql@spline.de>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Yann Michel
Date:
Subject: Re: CONNECT BY PRIOR
Next
From: Samer Abukhait
Date:
Subject: Re: CONNECT BY PRIOR