Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-docs-owner+archive@lists.postgresql.org>)
	id 1jbTgU-00071y-Ca
	for pgsql-docs@arkaria.postgresql.org; Wed, 20 May 2020 18:43:18 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-docs-owner+archive@lists.postgresql.org>)
	id 1jbTgT-0004e1-8o
	for pgsql-docs@arkaria.postgresql.org; Wed, 20 May 2020 18:43:17 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <alvherre@2ndquadrant.com>)
	id 1jbTgT-0004du-00
	for pgsql-docs@lists.postgresql.org; Wed, 20 May 2020 18:43:17 +0000
Received: from mail-qk1-x744.google.com ([2607:f8b0:4864:20::744])
	by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128)
	(Exim 4.92)
	(envelope-from <alvherre@2ndquadrant.com>)
	id 1jbTgM-0006IV-L2
	for pgsql-docs@lists.postgresql.org; Wed, 20 May 2020 18:43:16 +0000
Received: by mail-qk1-x744.google.com with SMTP id z80so4700538qka.0
        for <pgsql-docs@lists.postgresql.org>;
 Wed, 20 May 2020 11:43:10 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623;
        h=date:from:to:cc:subject:message-id:mime-version:content-disposition
         :content-transfer-encoding:in-reply-to:user-agent;
        bh=hcZC6ktDOEevJz8kX9rcTROSmSmZvem8G+p2sFXchdA=;
        b=LBLJ1HXpAibg3oWuyFZhhMgvTnYkAAtUySePEakmbKVDTZLZXZ8Cl38N8PA5kOwu+c
         adq54HAxGtI/wG6srmFnA0m1WshMfFGyt8ksl0+xSWUsj8uAX0MEXpkp2/ZCXtT3At9v
         VL97WSxfePPJ9ZoBxLTofOylT4dY6T4YU5pP1FCpfOnpBY1Ly1y5sm78SwVwMVG0a+vb
         jwkVmyCILFoHeAGgKyz87srBquWAcPR3tvgOQcyp4cc5ETy9FMmojc8svgq8I9ruDPcJ
         MWbQ2rBoY3xVtwTBlpOm5w/DdS1XKD7XIHxiLJdBbj8wEcXkO4Y2wfUBkprrl2lDti5f
         TMtA==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20161025;
        h=x-gm-message-state:date:from:to:cc:subject:message-id:mime-version
         :content-disposition:content-transfer-encoding:in-reply-to
         :user-agent;
        bh=hcZC6ktDOEevJz8kX9rcTROSmSmZvem8G+p2sFXchdA=;
        b=sQTyoK55icbBcQg3jwkqZ0tlNMgTcJfS0J8MITom4kWIlr4dr2M+4dc5XT3wzn1XMR
         x/XQ+FawirpjQzq5o4xm4kF6ujxp5A8alGKeVLLL8v7iiShD09sxWcYZ4a3pSu6OOiRt
         SxtOL4nTFkcNjUFc0mqeR4iheMPv9CS8OqBVItHGoU1ZQFIVsOd14TumH+OLOUHwonqe
         slkPU2g9CzBc2eSQGgu4uEjiZssRzCHSM6TbjHEjrNEd4Fo+0U1h8fxnIbG0SkHQp8S3
         iei3Me9EItrJ/h0Et4QxRR5vm21pU2FYFvWG5MNp/27lDtMA5Fc35AMlr5rj3UmA5Hb2
         Vjfg==
X-Gm-Message-State: AOAM531usUIT0BiDIIs21RZXk9TxeRchBnpdm9j0cJgqXqBES5+oQELa
	Rf0VizuqtX8LwxidLAB819N3bkl+vb/xukLpyrLivG+0+kRL3HmvT3OdPnKdyhxGJyepXlepoun
	/mjHgOic5/6dLMxYlv/KeC8h9BOW5MKDs8d8bF/ORp7n9qKSzckDQ3/ctMxINVgoG8Ffz2uC6su
	1tPekDgSB4y2Pu
X-Google-Smtp-Source: 
 ABdhPJwrmsEXH6Vu4AHxUlfkrM28CLjPqG21dbq3gM5Vc4WOJ80xxOkv0brX3fVy71SA2dPzikhUHg==
X-Received: by 2002:a37:a649:: with SMTP id p70mr6227347qke.307.1590000188939;
        Wed, 20 May 2020 11:43:08 -0700 (PDT)
Received: from nimloth.alvh.no-ip.org ([190.95.18.252])
        by smtp.gmail.com with ESMTPSA id
 t88sm3092883qtd.5.2020.05.20.11.43.07
        (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256);
        Wed, 20 May 2020 11:43:07 -0700 (PDT)
Received: by nimloth.alvh.no-ip.org (Postfix, from userid 1000)
	id 42AE6300305; Wed, 20 May 2020 14:43:05 -0400 (-04)
Date: Wed, 20 May 2020 14:43:05 -0400
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Pavel Luzanov <p.luzanov@postgrespro.ru>
Cc: pgsql-docs@lists.postgresql.org
Subject: Re: ATTACH/DETACH partitions and locking
Message-ID: <20200520184305.GA20830@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <53fb248b-94c6-1822-c5d7-8563fc9a2710@postgrespro.ru>
User-Agent: Mutt/1.10.1 (2018-07-13)
List-Id: <pgsql-docs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-docs@lists.postgresql.org>
List-Owner: <mailto:pgsql-docs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-docs>
Precedence: bulk

On 2019-Jun-14, Pavel Luzanov wrote:

> Does it make sense to change this way?
> "Some operations require a stronger lock when using declarative partitioning
> than when using table inheritance. For example, removing a
> partition from a partitioned table requires taking an ACCESS EXCLUSIVE
> lock on the parent table, whereas a SHARE UPDATE EXCLUSIVE lock is enough in
> the case of regular inheritance."

It took long -- pushed now.

Thanks for reporting

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services