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 20191102081911.GE23841@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)  (Michael Paquier <michael@paquier.xyz>)
List pgsql-hackers
Tree view 
On Fri, Nov 01, 2019 at 11:58:43AM -0500, Justin Pryzby wrote:
> 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 table to be attached and the <literal>DEFAULT</literal> partition (if
> any).
                

Sounds fine.  So gathering everything I get the attached.  Any
thoughts from others?
--
Michael
Attachment

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Remove configure --disable-float4-byval and--disable-float8-byval
Next
From: Julien Rouhaud
Date:
Subject: Re: [Proposal] Global temporary tables