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
