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 1ndwi3-0006Ua-SB for pgsql-admin@arkaria.postgresql.org; Mon, 11 Apr 2022 16:16:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ndwh3-0002xQ-ED for pgsql-admin@arkaria.postgresql.org; Mon, 11 Apr 2022 16:15:09 +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 1ndwh1-0002xG-Ky for pgsql-admin@lists.postgresql.org; Mon, 11 Apr 2022 16:15:09 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ndwgw-0002mm-Om for pgsql-admin@lists.postgresql.org; Mon, 11 Apr 2022 16:15:06 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id 8783C5C02A0; Mon, 11 Apr 2022 12:14:59 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Mon, 11 Apr 2022 12:14:59 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= quadratum-braccas.com; h=cc:content-transfer-encoding :content-type:date:date:from:from:in-reply-to:message-id :mime-version:reply-to:sender:subject:subject:to:to; s=fm2; t= 1649693699; x=1649780099; bh=pCLCJ0TlpboJ6ECaVSUizDl/NbhS91HBjZc j72h6GhQ=; b=Yhqg9ifv+95AIBxT6xqoii1bjUX+fvod4QbcFW4ZalGCMDJGWZ7 FGyK0agcDrqZLJwQMsMqmJ8dvySm+TEe6bKFaR1gcnQ2j8FNc3mIiB52mCwpI9E7 lJTP2sWYzs249AWfEiEX4Up2GgxRkAXOHd/2a9VCmBZdG/t1rc9zDi1dfSJK01l6 aFASNKxZuU1JSaBhBeHc+zOLiyiIBp707TZLI0w4PgDjQt5ZWeugZFZUN6yCt6SN iFDdxvQvRgJMY1MNAOf5Vlqqp8uKFdUcYyayxmE2hnhmJK0jyzc17AcdH7y9E4lc wuPKygAEiAuHEGwd4vATcHkkoqdEtMD8rkw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:date:from:from:in-reply-to:message-id:mime-version :reply-to:sender:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t=1649693699; x= 1649780099; bh=pCLCJ0TlpboJ6ECaVSUizDl/NbhS91HBjZcj72h6GhQ=; b=a ifxtuekXbXgt7b74QCdXOz2c757hCdR53I4PBfxrYz2m54jEpIbbK4O7HFbwRXml jaP2Y6rlZF3MsaEg7Azmw/GtCXH9fZ4qCFnhSWeHZlwIgustttJYgRjhueM8QKZ5 2Vq7z6qSMbphZu9j8Zqw05Yt8608NPDNsI936WYtbTkrzxf2IObN5dNOb0ubM44C u62hYH0YoROPpcI6VdVqn9sxhqrkkurBXWTLhbx5IjWMfaX+WL8kJIimNihMKw6n iCJannmVenkoMlidvOZKTsM6I0OuPcpz58nowb1pSjBySM9mLtJq9n5LTdAKK1ea dIDS3FTA2rHeDjubIDppA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvvddrudekiedguddttdcutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecunecujfgurhepkfffgggfvffhufgtgfesthejre dttdefjeenucfhrhhomhepufgsohgsuceoshgsohgssehquhgrughrrghtuhhmqdgsrhgr tggtrghsrdgtohhmqeenucggtffrrghtthgvrhhnpeegvdehheduvedtueejkefgfeehte dufffgteejfedtjefgtddtgedtjeehieduudenucevlhhushhtvghrufhiiigvpedtnecu rfgrrhgrmhepmhgrihhlfhhrohhmpehssghosgesqhhurggurhgrthhumhdqsghrrggttg grshdrtghomh X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 11 Apr 2022 12:14:58 -0400 (EDT) Message-ID: <548f2ed6-3209-705d-09e2-a5afbc6fb71c@quadratum-braccas.com> Date: Mon, 11 Apr 2022 10:14:57 -0600 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101 Thunderbird/91.7.0 To: pgsql-admin@lists.postgresql.org Content-Language: en-US From: Sbob Subject: set autocommit only for select statements Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi; Is there a way to set "autocommit = on" for all select statements and have "autocommit = off" for all other statements? Thanks in advance