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 <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1ndwlL-0006it-Gu
	for pgsql-admin@arkaria.postgresql.org; Mon, 11 Apr 2022 16:19:35 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1ndwlK-0001cQ-Bg
	for pgsql-admin@arkaria.postgresql.org; Mon, 11 Apr 2022 16:19:34 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <david.g.johnston@gmail.com>)
	id 1ndwlJ-0001Xw-WC
	for pgsql-admin@lists.postgresql.org; Mon, 11 Apr 2022 16:19:34 +0000
Received: from mail-ej1-x636.google.com ([2a00:1450:4864:20::636])
	by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128)
	(Exim 4.92)
	(envelope-from <david.g.johnston@gmail.com>)
	id 1ndwlH-00039f-Tn
	for pgsql-admin@lists.postgresql.org; Mon, 11 Apr 2022 16:19:32 +0000
Received: by mail-ej1-x636.google.com with SMTP id bg10so31985323ejb.4
        for <pgsql-admin@lists.postgresql.org>;
 Mon, 11 Apr 2022 09:19:31 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20210112;
        h=mime-version:references:in-reply-to:from:date:message-id:subject:to
         :cc;
        bh=JIw1Gzz4QFKkd50HkTNFlm7nKI6ee0hko/2rAcwbIeQ=;
        b=cdo7cWQCCMhnAXEuMsKgZLxRFbR0j0l+pYC9/xBm11QmqFTdv+beoA3NQOLw5m/T1r
         cNwpraVJJlRVoNYqzTRZVUNuDX5L8Abt5U3DhghxjmkifBKUdPw2g/VEEtlalwcKCtK9
         IOVvLn5GSGnNf49dD+YMfNPAL//TGrQ5c6sYLhzjszncEr9RgyMDKOgPGYnpuk88L+ip
         UPmrFUkPbHElZ8YShcrDpHL42EWOyIUu5IWnYtaSwnmOf7fV5LHkv4qzSJCzUMk16x2T
         c6Ka2wxTPo/zPlRQlhYmKsre6TGnSCk7GLT2pVNl4282yqRzCnf2fqOIG0Z677S7pFfw
         chug==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20210112;
        h=x-gm-message-state:mime-version:references:in-reply-to:from:date
         :message-id:subject:to:cc;
        bh=JIw1Gzz4QFKkd50HkTNFlm7nKI6ee0hko/2rAcwbIeQ=;
        b=bWoZqrmsf8ZYbsd6T/hZgaz+vVQQCfoNr+KxfSZJ3h8uvPrdlowaQjGoPp264ryhkA
         wCW6a6EPPY90pywtwvGBXn3PilGZJvJHrYqRPIobMBzXdBHOzvCYY7/gyg1QI5enevNb
         bUBEZHanlUEkPx2qSkUiRAVks7+Q8MVG1m6Co89OFTQ7sCR2fwJ1SHuZTEeuMdQfxz1b
         uthKLkOASpTCdA1Spryxy1nScMQA216wdIe3Ek0V8KC8qr+KuqAIW/OnxTEDFIQPI4tA
         btDYsIbRjyo19yNFcJZ3dWrSV8AcSDoaPCygnK2mFJXP3gQmf905AYBtKPXKJKTGDmiA
         YAPQ==
X-Gm-Message-State: AOAM530LyCIqq4YDJW3Dm2b445pIxVXrErN1QjBV8KUKw3CjdDH4F77a
	aHgilRTwl7U7NC36ZSwPrKCY2XwVJgIH3PRm/CWmet0X
X-Google-Smtp-Source: 
 ABdhPJxBS/XOMVXm+WN49U9zI6RKLtgTolh3AqjOYsmh6exOP4pRZwh9Mvy9N8mpfyjJ1GkfAhHxd61bUfW7Rd044Fo=
X-Received: by 2002:a17:907:971b:b0:6e8:67cf:6caf with SMTP id
 jg27-20020a170907971b00b006e867cf6cafmr13178335ejc.259.1649693970428; Mon, 11
 Apr 2022 09:19:30 -0700 (PDT)
MIME-Version: 1.0
References: <548f2ed6-3209-705d-09e2-a5afbc6fb71c@quadratum-braccas.com>
In-Reply-To: <548f2ed6-3209-705d-09e2-a5afbc6fb71c@quadratum-braccas.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Mon, 11 Apr 2022 09:19:13 -0700
Message-ID: 
 <CAKFQuwatWMes=XMstEfffoEQDCspdcc4GhA3WLNEwTVFgQusig@mail.gmail.com>
Subject: Re: set autocommit only for select statements
To: Sbob <sbob@quadratum-braccas.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000018866105dc634f44"
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwatWMes%3DXMstEfffoEQDCspdcc4GhA3WLNEwTVFgQusig%40mail.gmail.com>
Precedence: bulk

--00000000000018866105dc634f44
Content-Type: text/plain; charset="UTF-8"

On Mon, Apr 11, 2022 at 9:15 AM Sbob <sbob@quadratum-braccas.com> wrote:

> Is there a way to set "autocommit = on" for all select statements and
> have "autocommit = off" for all other statements?
>
>
In what?  The server doesn't have an autocommit option.

But I doubt it; regardless of the answer to the previous question.

David J.

--00000000000018866105dc634f44
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Mon, Apr 11, 2022 at 9:15 AM Sbob &lt;<a href=3D"mailto=
:sbob@quadratum-braccas.com">sbob@quadratum-braccas.com</a>&gt; wrote:</spa=
n><br></div></div><div class=3D"gmail_quote"><blockquote class=3D"gmail_quo=
te" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204=
);padding-left:1ex">Is there a way to set &quot;autocommit =3D on&quot; for=
 all select statements and <br>
have &quot;autocommit =3D off&quot; for all other statements?<br><br></bloc=
kquote><div><br></div><div class=3D"gmail_default" style=3D"font-family:ari=
al,helvetica,sans-serif">In what?=C2=A0 The server doesn&#39;t have an auto=
commit option.</div><div class=3D"gmail_default" style=3D"font-family:arial=
,helvetica,sans-serif"><br></div><div class=3D"gmail_default" style=3D"font=
-family:arial,helvetica,sans-serif">But I doubt it; regardless of the answe=
r to the previous question.</div><div class=3D"gmail_default" style=3D"font=
-family:arial,helvetica,sans-serif"><br></div><div class=3D"gmail_default" =
style=3D"font-family:arial,helvetica,sans-serif">David J.</div><div class=
=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif"></div><=
div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif=
"><br></div></div></div>

--00000000000018866105dc634f44--