pg_dump LOCK TABLE ONLY question
Hi.
I'm running pg_dump constrained to one schema. It appears that pg_dump runs
"LOCK TABLE %s IN ACCESS SHARE MODE" for each table.
Naturally it makes sense, but...
This schema has a table that serves as parent for thousands of child
tables (via INHERITS).
So effectively, to dump this schema, I have to LOCK all these tables
not only parent.
pg_dump does it automatically, I checked in current trunk - it does
not add ONLY keyword. Should it?
I wonder if it it counts as a bug.
If not a bug, maybe it counts as a feature request?
Thanks.
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
=?UTF-8?Q?Filip_Rembia=C5=82kowski?= <filip.rembialkowski@gmail.com> writes:
I'm running pg_dump constrained to one schema. It appears that pg_dump runs
"LOCK TABLE %s IN ACCESS SHARE MODE" for each table.
Naturally it makes sense, but...
This schema has a table that serves as parent for thousands of child
tables (via INHERITS).
So effectively, to dump this schema, I have to LOCK all these tables
not only parent.
They'd all end up locked anyway wouldn't they?
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers