Re: update ALTER TABLE with ATTACH PARTITION lock mode (docs)

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Justin Pryzby <pryzby(at)telsasoft(dot)com>
Cc: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: update ALTER TABLE with ATTACH PARTITION lock mode (docs)
Date: 2019-10-31 09:07:34
Message-ID: 20191031090734.GH2530@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fabien COELHO 2019-10-31 09:09:14 Re: Getting psql to redisplay command after \e
Previous Message Michael Paquier 2019-10-31 08:55:55 Re: [PATCH] Do not use StdRdOptions in Access Methods