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 ) id 1n9pcI-0004iq-0I for pgsql-docs@arkaria.postgresql.org; Tue, 18 Jan 2022 14:37:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n9pcF-00078y-HS for pgsql-docs@arkaria.postgresql.org; Tue, 18 Jan 2022 14:37:43 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n9pcF-00078m-3e for pgsql-docs@lists.postgresql.org; Tue, 18 Jan 2022 14:37:43 +0000 Received: from mail-wm1-x336.google.com ([2a00:1450:4864:20::336]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1n9pcA-00074p-3L for pgsql-docs@lists.postgresql.org; Tue, 18 Jan 2022 14:37:42 +0000 Received: by mail-wm1-x336.google.com with SMTP id ay4-20020a05600c1e0400b0034a81a94607so8056180wmb.1 for ; Tue, 18 Jan 2022 06:37:37 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20210112.gappssmtp.com; s=20210112; h=message-id:subject:from:to:date:in-reply-to:references:user-agent :mime-version:content-transfer-encoding; bh=4/tYVAUO1p0JqPXZf7aBlmkPZMdJhw9o4s4HTiDWVGc=; b=jgOeSQHdJ69mkPnFek5ry81AykEtDQI3p2gHDvTv7J5nn+HnSeXS4S0xiqapzS3Yxy sDhdBFyCTTpImQm8xJfvR7jRa1QG9Am9yEAan4cM+TCOOxxi2vsUHC/OVIov3hLu72i1 UOKQ9bBH0v7J601LHHEt//8FF99PPbaaBrzvTTSYAOnoAtJ7Ae+Y/ewlp1j5u7McJ3lX 1isUOrwN6cKyLScDQunvLXHg0dtOXc1b1F2LRGaQacsvy+WpxVYnOD1XyOMBV9Avp/Vz UR5ZI7dxO+9wVGMuY9DoX+hq97Ps2yxZrivTdddwpFEj6A13vpFB8PIYCw7YDVm+K4qf jjlg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:message-id:subject:from:to:date:in-reply-to :references:user-agent:mime-version:content-transfer-encoding; bh=4/tYVAUO1p0JqPXZf7aBlmkPZMdJhw9o4s4HTiDWVGc=; b=m2V31MD/s83yJg2XUAiHmfOtRwo5qguACFpDAmbM+qJNSE5rznvOaMgOO1QVkG6OER /HKJznEOVIKog776E4a0SYCC82Emdz7rNr0p2e2xV2tTdOGxu7r4c3JTF20TUY+sbuLa xzHIn/8/TiZGva3ZC+CAzj0oLnmgzrZiza7XCK0EAGHDVjqezlvHqtFBb16V1fgtvDy3 eXL6X7v41xzuJwVesXJZlUuDJaJYH9BWdsuGxOB/reC+gxnJxBXcZZY7lhOJLyT9V6KF cXte40BpwBkQ2oUm6LuKr2OgZSGu7vF4OWTRq24HhYkD6Qhs0tR2/0FvkWC0Tm6/IHuq HVTw== X-Gm-Message-State: AOAM5322xNKediJAc0LHIUJUqZRIvxv3QouX02flI8ZCk3sncsZUmVWB V7qkH1mILwEvL1EO9dUvxIpYfJ5iV1i184xI X-Google-Smtp-Source: ABdhPJy80PaxsfUQI3E1xxRnfw4CsnAUupwopO5N0kczI+Lk370RGM/85PmpLiGjBq8qlgpnL/skpQ== X-Received: by 2002:a05:600c:a45:: with SMTP id c5mr32309018wmq.127.1642516656490; Tue, 18 Jan 2022 06:37:36 -0800 (PST) Received: from localhost.localdomain (dynamic-ea2xm3akjdt7de6ae-pd01.res.v6.highway.a1.net. [2001:871:5e:253:6a04:4ffe:c682:d056]) by smtp.gmail.com with ESMTPSA id f15sm1005287wrd.45.2022.01.18.06.37.35 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 18 Jan 2022 06:37:36 -0800 (PST) Message-ID: Subject: Re: COMMENT ON lock From: Laurenz Albe To: "nikolai.berkoff" , "pgsql-docs@lists.postgresql.org" Date: Tue, 18 Jan 2022 15:37:35 +0100 In-Reply-To: <_0HDHIGcCdCsUyXn22QwI2FEuNR6Fs71rtgGX6hfyBlUh5rrnE2qMmvIFu9EY4Pijr2gUmJEAXCjuNU2Oxku9TryLp9CdHllpsCfN3gD0-Y=@pm.me> References: <_0HDHIGcCdCsUyXn22QwI2FEuNR6Fs71rtgGX6hfyBlUh5rrnE2qMmvIFu9EY4Pijr2gUmJEAXCjuNU2Oxku9TryLp9CdHllpsCfN3gD0-Y=@pm.me> Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.40.4 (3.40.4-2.fc34) MIME-Version: 1.0 Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, 2022-01-18 at 14:11 +0000, nikolai.berkoff wrote: > I wanted to know what lock the COMMENT ON command took and I had to look in the > source code, makes sense to me that it should be documented.  I've also added > it to the list of commands that take a SHARE UPDATE EXCLUSIVE lock. +1, but SHARE ACCESS EXCLUSIVE should be marked up with . Yours, Laurenz Albe