=?UTF-8?Q?Filip_Rembia=C5=82kowski?= <filip.rembialkow...@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