Postgres Pro
Downloads
Home   >   mailing lists

Re: update ALTER TABLE with ATTACH PARTITION lock mode (docs) - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: update ALTER TABLE with ATTACH PARTITION lock mode (docs)
Date
Msg-id 20191031090734.GH2530@paquier.xyz
Whole thread Raw
In response to Re: update ALTER TABLE with ATTACH PARTITION lock mode (docs)  (Justin Pryzby <pryzby@telsasoft.com>)
Responses Re: update ALTER TABLE with ATTACH PARTITION lock mode (docs)
List pgsql-hackers
Tree view 
On Mon, Oct 28, 2019 at 10:56:33PM -0500, Justin Pryzby wrote:
> I suppose it should something other than partition(ed), since partitions can be
> partitioned, too...
>
>       Attaching a partition acquires a <literal>SHARE UPDATE EXCLUSIVE</literal>
>       lock on the parent table, in addition to
>       <literal>ACCESS EXCLUSIVE</literal> locks on the child table and the
>       <literal>DEFAULT</literal> partition (if any).

In this context, "on the child table" sounds a bit confusing?  Would
it make more sense to say the "on the table to be attached" instead?
--
Michael
Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [PATCH] Do not use StdRdOptions in Access Methods
Next
From: Fabien COELHO
Date:
Subject: Re: Getting psql to redisplay command after \e