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 1qwOwY-00BSgj-HT for pgsql-docs@arkaria.postgresql.org; Fri, 27 Oct 2023 15:40:14 +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 1qwOwW-00Gq3v-Kn for pgsql-docs@arkaria.postgresql.org; Fri, 27 Oct 2023 15:40:12 +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 1qwOwW-00Gq3n-D4 for pgsql-docs@lists.postgresql.org; Fri, 27 Oct 2023 15:40:12 +0000 Received: from momjian.us ([72.94.173.45]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qwOwT-002arf-M0 for pgsql-docs@lists.postgresql.org; Fri, 27 Oct 2023 15:40:11 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=momjian.us; s=2023062407; h=In-Reply-To:Content-Type:MIME-Version:References:Message-ID: Subject:To:From:Date:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description; bh=TYD856ie29qTAzI/AwgCmc67CAXKM/foB3Qizh3txyk=; b=YMDe0 QdGZPI7o6wy39iKntxYJXzIJp+W3R+lBJOdm0Uq2RBxxInBNkoPWuqq2OUix6F4C9AwduMvf8+271 APbERxpDmidbNH5C5jbqL6e6q4MEwey04orGJWnMT5RScKAjl0qNQMYorWbD1heSB4hfB8LA1e+ZM VdPSJALR6aGJxp/4K5y9RWcnYajdyWHqIqGgJ4qinxXC162omVNyC+L2XOW4ipK4g3lx7h+6PdXuN FoRkM5oykMAke9hDw3IFNNnMc78ZRVkugJMhwPnc9kIHNkMXdWX7hKEe3eDmDsJZ0GayYTTUwLAO6 N60Bc+YWWRMJcsjTll7Sq7SP/oOjg==; Received: from bruce by momjian.us with local (Exim 4.96) (envelope-from ) id 1qwOwS-003nGk-2a; Fri, 27 Oct 2023 11:40:08 -0400 Date: Fri, 27 Oct 2023 11:40:08 -0400 From: Bruce Momjian To: andyatkinson@gmail.com, pgsql-docs@lists.postgresql.org Subject: Re: [very minor] Documentation suggestion Message-ID: References: <166631875298.630.2861049399528658047@wrigleys.postgresql.org> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="vegSJkjh11AEgO54" Content-Disposition: inline In-Reply-To: <166631875298.630.2861049399528658047@wrigleys.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --vegSJkjh11AEgO54 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Fri, Oct 21, 2022 at 02:19:12AM +0000, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/15/logicaldecoding-synchronous.html > Description: > > Very minor suggestion. Earlier on this page, commands are referred to that > can cause "a deadlock". Later on the page, it says "cause deadlock". > > https://www.postgresql.org/account/comments/new/15/logicaldecoding-synchronous.html/ > > "Note that these commands that can cause deadlock" The full sentence is: Note that these commands that can cause deadlock apply to not only explicitly indicated system catalog tables above but also to any other [user] catalog table. What I think it means is: Note that these commands, that can cause deadlock, apply to not only explicitly indicated system catalog tables above but also to any other [user] catalog table. so with "a" it would be: Note that these commands, that can cause a deadlock, apply to not only explicitly indicated system catalog tables above but also to any other [user] catalog table. but it still needs help ;-) Here is the text I just applied: Note that these commands can cause deadlocks not only for the system catalog tables listed above but for other catalog tables. Attached is the applied patch to master. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you. --vegSJkjh11AEgO54 Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename="master.diff" commit 16ace6f745 Author: Bruce Momjian Date: Fri Oct 27 11:35:47 2023 -0400 doc: clarify logical decoding's deadlock of system tables Reported-by: andyatkinson@gmail.com Discussion: https://postgr.es/m/166631875298.630.2861049399528658047@wrigleys.postgresql.org Backpatch-through: master diff --git a/doc/src/sgml/logicaldecoding.sgml b/doc/src/sgml/logicaldecoding.sgml index 5af016cfa9..8067946a25 100644 --- a/doc/src/sgml/logicaldecoding.sgml +++ b/doc/src/sgml/logicaldecoding.sgml @@ -1197,9 +1197,8 @@ OutputPluginWrite(ctx, true); - Note that these commands that can cause deadlock apply to not only explicitly - indicated system catalog tables above but also to any other [user] catalog - table. + Note that these commands can cause deadlocks not only for the system + catalog tables listed above but for other catalog tables. --vegSJkjh11AEgO54--