Re: pg_dump LOCK TABLE ONLY question

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