Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gmBo2-0007t3-EC for pgsql-docs@arkaria.postgresql.org; Wed, 23 Jan 2019 06:14:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gmBo0-0007Px-P1 for pgsql-docs@arkaria.postgresql.org; Wed, 23 Jan 2019 06:14:32 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gmBo0-0007OH-HL for pgsql-docs@lists.postgresql.org; Wed, 23 Jan 2019 06:14:32 +0000 Received: from out5-smtp.messagingengine.com ([66.111.4.29]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gmBny-0002dm-Aa for pgsql-docs@lists.postgresql.org; Wed, 23 Jan 2019 06:14:32 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id B2BF221FEC; Wed, 23 Jan 2019 01:14:27 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Wed, 23 Jan 2019 01:14:27 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm3; bh=zHhoWD6rTPpsjt2MOtqisyAlvrk 1nLMxs5HuOYhzZoM=; b=oyPnQ41GfNM0kEDGvlgQuN6uZehsVolzAlryhkBsa2z 88EpSUO7NAK+h6F4PnssrVgNLznMrk6eVR00EjS4QIJOuqmMFnUqg9VRP7TrYuBY JpKIWdtqj6gPw9bvNC+0WuTjB+zSQgpA4Pd7N/GSzryrH9ojygH7SuEE6ISEb+sK TvD7jtaSfiZZYXOSoo9XQwbFtc8moV+h/rdHTPfuLehNcp1ELO37q2Pl931KGAnU 5qbNyhPGLP+m/6IvzHc6yYTZTryyUOiiEA/Hud475FQRliKRiqds6JP4Rwn7nkGd gHodslCfy5/yFlJa+58m1gEC3pfHNBE1qlhnpoVloTQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; bh=zHhoWD 6rTPpsjt2MOtqisyAlvrk1nLMxs5HuOYhzZoM=; b=uN2Yv6IGIYlnsd6KAvtPbH csUqwjiBqcQAPjTiE+uVyQiNxeFyIyMaRib+SfwKhvnPgO8VbB6OritruHDZfmR3 V2BnGKu9xljNqU1VSNgKSYnXU/LTpqgMj6PasaU2kSbMvYZAUPj7w4YtHwJcyGSY lGswFM8BJBNO/JQLki1dM8VvJpTt1JEW0IFhpouE0RJqKKugaIgPcxzXq5BUKivK uO9HCVzhrYXJ9MbtVwoqb4KSfeMU310zPfPg8/itOamP1CuZkOGOWfIu2LknfRIW mcNs1hMHlFjltarS+ESD+WSj9A28xxaKy2a+GzWT9lCz9u7hy0dgY3gPOqYJMQHw == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedtledrheelgdelhecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfhuthenuceurghilhhouhhtmecufedt tdenucesvcftvggtihhpihgvnhhtshculddquddttddmnegfrhhlucfvnfffucdljedtmd enucfjughrpeffhffvuffkfhggtggujgesghdtreertddtvdenucfhrhhomhepofhitghh rggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprghquhhivghrrdighiiiqeenuc fkphepiedurddvudehrddufeejrdduiedvnecurfgrrhgrmhepmhgrihhlfhhrohhmpehm ihgthhgrvghlsehprghquhhivghrrdighiiinecuvehluhhsthgvrhfuihiivgeptd X-ME-Proxy: Received: from paquier.xyz (c137162.net61215.cablenet.ne.jp [61.215.137.162]) by mail.messagingengine.com (Postfix) with ESMTPA id 4121610087; Wed, 23 Jan 2019 01:14:25 -0500 (EST) Date: Wed, 23 Jan 2019 15:14:22 +0900 From: Michael Paquier To: Tom Lane Cc: Pavlo Golub , pgsql-docs@lists.postgresql.org Subject: Re: `transaction_read_only` GUC undocumented Message-ID: <20190123061422.GK3873@paquier.xyz> References: <20190123002536.GC3873@paquier.xyz> <18fa8fbf-f5a3-4e4b-b751-8b9da58c117c@email.android.com> <20190123055440.GI3873@paquier.xyz> <4210.1548223651@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="gw4vLALk08fVJy3V" Content-Disposition: inline In-Reply-To: <4210.1548223651@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --gw4vLALk08fVJy3V Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Wed, Jan 23, 2019 at 01:07:31AM -0500, Tom Lane wrote: > Michael Paquier writes: >> transaction_read_only is listed in src/backend/utils/misc/guc.c, so we >> could put a description close to default_transaction_read_only in >> config.sgml, except that transaction_read_only sets the current >> transaction's read-only status. >=20 > Do we really want to document that? It's not the standard-approved > way of making a transaction read-only. i'd rather document them clearly rather than letting them around with users guessing what they actually do (remember the recent thread about replication parameter in connection strings). By the way, I can see that transaction_deferrable and transaction_isolation are not around either... -- Michael --gw4vLALk08fVJy3V Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlxIBj4ACgkQnvQgOdby QH3nmBAAlBmKyR/H9ipy8qoCx/FW7lu4E+1JbHm2QddSr+U1tZSk2ZDCG+WoqzQp jAYkF1pwllOPBhc/2LYX1nGc1/QC+7slWPG0wz07ZT4x95n8noKGcl7FBFoCZR0A aOQmKZj0D+KootC4FPKHC/k8l81mQ6fsA+8u9C850Go89PbDuWF1mKtKqBNvEQJp Jr7b5OvVs5Xt+mTZ5xv4WFU+MeU1tAhku9y/gYnQfvHksHYAzUQCNEyz0XMqd424 UI2IC4WqhQiMl0Opky8dqi4K7+JzVF2EVWHm4TLqC0ExTws0WPYdw1Fz2ft9istp 5NEMgElVvfy5Em52bXXHNWbfwJi70IOPKRWmBD9FHrHpSGgZOR8H0Rs8En1E7K+M M/9jM6v6xe+WtmVRjtH2xgQP3gGdtgsqDevFtN8sEGmoO0AOSJIUXVDgdt5hALJ6 RPBlOTD36ZwnMO+v4pSotvXyczkvX3pzo5DMmXMynyc9yPFbFxJ6crQ/SxKGlmcr B+A4t3/Jts4CLXSyyjuqQ4C9wSbeGqW3UiWPG5Xc1yVgqMvMScr1WAstfirRz5SU red9R89eGCjcNfe0w7Vq/Cg/i9jo5TNgMYQVfTnUwgJHoTp1Wyg5wYyVziLQrja9 Gb78DXZh9fkaRRINVIStSKsnDFnGkDuKd+WF80IAaHOyqUerNgc= =a5Hw -----END PGP SIGNATURE----- --gw4vLALk08fVJy3V--