Filip Rembiałkowski <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