On Sat, Oct 31, 2015 at 10:14:18AM +0100, Simon Riggs wrote:
> I agree with Filip that this is a bug. pg_dump clearly doesn't work
> correctly with inheritance.
>
> If I run this command
>
> pg_dump -t tab1
>
> then I get a dump of "tab1". No data is included from tables that inherit
> tab1 because COPY refers only to the target table.
>
> Why should that action cause a lock to be taken on another table that
> inherits from tab1?
>
> It seems clear that the user is requesting an action ONLY on tab1, so we
> should use LOCK TABLE tab1 ONLY;
+1
