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 1neFy0-0007fr-QK for pgsql-admin@arkaria.postgresql.org; Tue, 12 Apr 2022 12:49:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1neFxz-00023B-LW for pgsql-admin@arkaria.postgresql.org; Tue, 12 Apr 2022 12:49:55 +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 ) id 1neFxy-00022y-W7 for pgsql-admin@lists.postgresql.org; Tue, 12 Apr 2022 12:49:55 +0000 Received: from mail-oa1-x2e.google.com ([2001:4860:4864:20::2e]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1neFxv-0004zC-RJ for pgsql-admin@lists.postgresql.org; Tue, 12 Apr 2022 12:49:53 +0000 Received: by mail-oa1-x2e.google.com with SMTP id 586e51a60fabf-d6ca46da48so20585028fac.12 for ; Tue, 12 Apr 2022 05:49:51 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=90cZ9eDSUWlvP+GLsAIiAwZrfDvwAYmZliXSWfzSW6w=; b=j3JQJUjXM3WxMOHeEGoCnZpTq3ezQlU7obKrA5B4By0JH+hYXtO/649drTpIsexkJQ qBUVMBXhr+5YMS20UQk2myeKqVpzPuGxD/6eXwKvqhDYuq3A3xA9SNNpeTeQ55JXNHTl hHj45hdNndenKZRTdN+dynwOgvuEyxetrTEneJ7Y6iI3uY2EV2ktXrKsn6wcm+7zu709 6gBqlmerEsjuBsM2A+styRQmlyW9j0SBZAQBA5b+JC8krqiGzDOcquTpBM5cX6XbGTBR sNF8MITp1dksjHPvZZO6l4wAShQt4/cQ4n6/GRVsfUigx1dyQK345hb6baCaGZKhfj7p vvQA== 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=90cZ9eDSUWlvP+GLsAIiAwZrfDvwAYmZliXSWfzSW6w=; b=ZzyP8BCfRuNEkyLlxLpfTuS30FEGnZzbe6t+Mq9VqBMi5cvqoOejlGXCfWAqNJhi3D 8GKJ1k7oVv3IG1MDvC+Z++Q9l2r+LNY2U1mGRB7ReZDYo3klAxFA+VeGWGGYqYuJJN8M 2sf+3r++RYb5MO6I51Z7rxqfunIzql5ZCQkxSPHb7SsKCqkiMVAmonyfMfIVUPGU6ezY mSa3MHaVu9drE7BasON8IrRTdOLAcp2MVk8LIDXnPkvbF1LbPf4vnrL90DcsVxX0JFQe yK9/RzBlIGLTR4ehFttvdzUWvnB1sMlkhpjqEx8uszVVmIkdPTaUJzwTp2vYWOZMxYLs WQeg== X-Gm-Message-State: AOAM531y8yYM6uw8VZsrzQ51p7sLYSdv+4v61zAEPE0eZH6/DHEo8JKg KlnOPu+nI3DyZ5DSckn0+2CO2hAshXWLbitQ80ZNLxoE4VW7EBo4lZugQRD3eGXLSZ3CwLAcXBo AEJDibmxFwhX2JsLHURRB5MLftIjtfwFJ2Xas+lkHTjRohkgR68wf8Gp1hEyBBcAZeKHFdBHJfv mX7t9dTtixGqSHzGAYz5dVppblmvDZYsTORGN8+oAY8Zr/UdKxmvyPXwHZLZru14o= X-Google-Smtp-Source: ABdhPJy3kEl+a55ZOcT1nTQ/FsxQv+sfb3pCsORSRzTh3cSawuzmMIfMKusJaSMyP90WBcJXMYFBquR9/lthSlVT9e0= X-Received: by 2002:a05:6870:d68e:b0:e2:861:8b15 with SMTP id z14-20020a056870d68e00b000e208618b15mr1988055oap.156.1649767790930; Tue, 12 Apr 2022 05:49:50 -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: Simon Riggs Date: Tue, 12 Apr 2022 13:49:39 +0100 Message-ID: Subject: Re: set autocommit only for select statements To: Sbob Cc: Pgsql-admin Content-Type: text/plain; charset="UTF-8" X-CLOUD-SEC-AV-Info: enterprisedb,google_mail,monitor X-CLOUD-SEC-AV-Sent: true X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 11 Apr 2022 at 17:15, Sbob wrote: > Is there a way to set "autocommit = on" for all select statements and > have "autocommit = off" for all other statements? Please explain what it is you are hoping to achieve? -- Simon Riggs http://www.EnterpriseDB.com/