Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sFmEY-005wW2-I0 for pgsql-docs@arkaria.postgresql.org; Sat, 08 Jun 2024 02:55:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sFmDX-00F8Xh-8z for pgsql-docs@arkaria.postgresql.org; Sat, 08 Jun 2024 02:54:08 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sFmDW-00F8XY-89 for pgsql-docs@lists.postgresql.org; Sat, 08 Jun 2024 02:54:07 +0000 Received: from fhigh4-smtp.messagingengine.com ([103.168.172.155]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sFmDT-000Fb9-3y for pgsql-docs@lists.postgresql.org; Sat, 08 Jun 2024 02:54:04 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.46]) by mailfhigh.nyi.internal (Postfix) with ESMTP id DC596114022C; Fri, 7 Jun 2024 22:54:01 -0400 (EDT) Received: from imap49 ([10.202.2.99]) by compute2.internal (MEProxy); Fri, 07 Jun 2024 22:54:01 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=eulerto.com; h= cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm2; t=1717815241; x=1717901641; bh=LWx3B1YA8A O0cSsPpxID5BBZ6/9Ycbq4BcUkgzQlw7I=; b=GAEylUb9Pfu0BhcuJfY282w505 4DIEs63/IMCxgpyCQWEVzpf0TZUSR2B4x3r9Hs4Dh/iabh6Ps3Rj2uEzAkzSOPGo KXXDkSWxqDSP+/2zDwVE+s8QJ0VLGelhJ0NZiIdSEy0weUBXpZ1beaHpCWNsXM7D R+453vBQyr7a1PVeuGgCXJ6B8T51l+ZhBxjRdwPUbWlod+ouFJdjKaO2ZDM5JxhC N5wJdRBTMgTPL1xYgjy/CoRGubI/LB2kAWljvQrgsbViFgrT5mrGlgeZRtp+Ndxv NL465uPn1m0jcUiamLVbaKTfPjboEGMHBJ2pqf5Sf6ljqaUJEvFHhzX3HFyg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm1; t=1717815241; x=1717901641; bh=LWx3B1YA8AO0cSsPpxID5BBZ6/9Y cbq4BcUkgzQlw7I=; b=Jjn317Ak9HoI0WkCkkc47Ez81TVlUtBNujlb2BQuYco7 AzDgwzmCqFOcVBWyCLT8T/f42DZ1HuISvfaFQgGy4UVzepB1aLtqBfzaVb/Vz297 e7s7RVEbVTUGnHdh38u86YkLDxfE+kMBks5SAlmqylqfIq+9dlVtJTI2y9vaV+l6 Kc7vDYvNi0VihSflqDiaE52EcFixUf9y3s531+9b3jpZFrOxV3q2lQRwwlsF7z7c gRooonN0LysS7POiaybWQ9QkpBmzlLtlCgGEgwRkN20X9zn0/e8VXwQtDmvnzlBU pCGjLFAY4S+IZ5VSBDSsk38K22PTzoJmdAhwsnhrxA== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvledrfedtvddgiedvucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepofgfggfkjghffffhvffutgesrgdtreerreertdenucfhrhhomhepfdfguhhl vghrucfvrghvvghirhgrfdcuoegvuhhlvghrsegvuhhlvghrthhordgtohhmqeenucggtf frrghtthgvrhhnpedtjeffieeuieeggeehieeutdevleetteejiedtgfehheefueekveff tedujefhffenucffohhmrghinhepphhoshhtghhrvghsqhhlrdhorhhgpdgvnhhtvghrph hrihhsvggusgdrtghomhenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgr ihhlfhhrohhmpegvuhhlvghrsegvuhhlvghrthhordgtohhm X-ME-Proxy: Feedback-ID: i0c21471d:Fastmail Received: by mailuser.nyi.internal (Postfix, from userid 501) id 8F04B15A0092; Fri, 7 Jun 2024 22:54:01 -0400 (EDT) X-Mailer: MessagingEngine.com Webmail Interface User-Agent: Cyrus-JMAP/3.11.0-alpha0-497-g97f96844c-fm-20240526.001-g97f96844 MIME-Version: 1.0 Message-Id: In-Reply-To: References: Date: Fri, 07 Jun 2024 23:53:40 -0300 From: "Euler Taveira" To: "Dull Bananas" , pgsql-docs@lists.postgresql.org Subject: Re: DROP TRIGGER lock Content-Type: multipart/alternative; boundary=dd6f34db9434467289f41cdc5cbfe404 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --dd6f34db9434467289f41cdc5cbfe404 Content-Type: text/plain On Fri, Jun 7, 2024, at 12:06 PM, Dull Bananas wrote: > On these pages, it should be mentioned that DROP TRIGGER acquires an ACCESS EXCLUSIVE lock: > > https://www.postgresql.org/docs/16/explicit-locking.html#LOCKING-TABLES > > https://www.postgresql.org/docs/16/sql-droptrigger.html If I would add such information it would be in the latter. AFAICS the former provides some examples of SQL commands that take AccessExclusiveLock. If you search for AccessExclusiveLock into src/backend/commands/* you will notice that there are more commands that were not mentioned in the Table-Level Locks section. Feel free to propose a patch. -- Euler Taveira EDB https://www.enterprisedb.com/ --dd6f34db9434467289f41cdc5cbfe404 Content-Type: text/html Content-Transfer-Encoding: quoted-printable
On Fri, Jun 7, = 2024, at 12:06 PM, Dull Bananas wrote:
On these pages, it should be mentioned that = DROP TRIGGER acquires an ACCESS EXCLUSIVE lock:




If I would add such informat= ion it would be in the latter. AFAICS the former
provides = some examples of SQL commands that take AccessExclusiveLock. If you
<= /div>
search for AccessExclusiveLock into src/backend/commands/* you= will notice that
there are more commands that were not me= ntioned in the Table-Level Locks
section.
Feel free to propose a patch.

=
--
=
Euler Taveira
EDB   https://www.e= nterprisedb.com/

--dd6f34db9434467289f41cdc5cbfe404--