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 1sK1dE-007wSc-Ob for pgsql-general@arkaria.postgresql.org; Wed, 19 Jun 2024 20:10:13 +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 1sK1dC-006CQX-Dj for pgsql-general@arkaria.postgresql.org; Wed, 19 Jun 2024 20:10:11 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sK1dB-006CQL-5O for pgsql-general@lists.postgresql.org; Wed, 19 Jun 2024 20:10:11 +0000 Received: from fout4-smtp.messagingengine.com ([103.168.172.147]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sK1d8-002Wea-7x for pgsql-general@postgresql.org; Wed, 19 Jun 2024 20:10:09 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.46]) by mailfout.nyi.internal (Postfix) with ESMTP id A423113801F2; Wed, 19 Jun 2024 16:10:03 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute2.internal (MEProxy); Wed, 19 Jun 2024 16:10:03 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:content-transfer-encoding:content-type:content-type:date:date :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm1; t=1718827803; x=1718914203; bh=FC5DnygnVFMiMoUGnlKEkcRqAX6rtZJ5qf6btHzolSo=; b= vTzHIjVJpuyDQEzQAKt1ismaNLsMaaM35TEifAp2WhrBBBNNzgDbMP1HkHnBItMu 88wY0LJ/mzz6rpRVfSbje3GK6rIHxS8q5XTcVOOwupKd6iBz3jHVUq9mNpYLto1n IiMUmyDXCY/r+M2x13zLr2aSvr8HEBH8waYkv1a2i2fMB87zX2uFjlbVzbcJ77tV GUwwRKHdhghtDt2UVJK7MjUhiHkVk54tNrI569M/r3cROvZFyTxe0bVRKYJqExJe 3lYRENfOPhkgKVEK2Yz56nDYv3KuvMFrMu5CZMm+DMVvTs/8kcTwCLz5GpS8X65W t0h0SFI1HMp1yby/gY70iw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t=1718827803; x= 1718914203; bh=FC5DnygnVFMiMoUGnlKEkcRqAX6rtZJ5qf6btHzolSo=; b=m BmAJitT+xixdLckwqNHD1dq+PiOuP0BLA0P2GmuoulDo8h0YTeGEotGxj+WKMM28 SStq3ovOEk9trJnJeMbObBwoSeOHiT+pz6QMrQ9+mZmAjyjsd37nk64/9WlRCcCH TLD3UTQM8j7alt0rHUhj0UxSIo2aHHTXCSjSKDZwnqNwq2QwlAvvPUMAo3+sygqt +dszpAUWsnMyteNd37DNi2A9c5F94cjL4NQu7/o5+4H9fpszMU1HPLCwmqM1rPTp yA79pBiIsL6OUJObuWHvb9+qn3G3THs+jtCLLGMgHPVJbwS9UvBtsMRGwrMxRYKC EVzHqBGsP5rcHBrfArX8A== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvledrfeeftddgudeghecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmd enucfjughrpefkffggfgfuvfhfhfgjtgfgsehtjeertddtvdejnecuhfhrohhmpeetughr ihgrnhcumfhlrghvvghruceorggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtg homheqnecuggftrfgrthhtvghrnhepiedvhfeiheehgeeuieeljeeitedtjeehudegfeel kedvleekhedtgfeiffefkedunecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpe hmrghilhhfrhhomheprggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomh X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 19 Jun 2024 16:10:02 -0400 (EDT) Message-ID: Date: Wed, 19 Jun 2024 13:10:02 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Transaction issue To: Rich Shepard , pgsql-general@postgresql.org References: <4773397e-dec5-4c0a-bbfc-ea5794805c4d@aklaver.com> <23351ad6-5a62-64e5-63e-8364b9f4f774@appl-ecosys.com> <2a523214-5f72-ace5-3055-ca734d909f4f@appl-ecosys.com> Content-Language: en-US From: Adrian Klaver In-Reply-To: <2a523214-5f72-ace5-3055-ca734d909f4f@appl-ecosys.com> 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 On 6/19/24 12:40, Rich Shepard wrote: > On Wed, 19 Jun 2024, Adrian Klaver wrote: > >> Are there transaction statements e.g. BEGIN;, COMMIT; in the script? > > Adrian, > > Yes, each script has BEGIN; on line 1. Does it have a COMMIT; at the end? At this point I think you need to create a simple test case where: 1) You have script with BEGIN; COMMIT; 2) In psql do \i 3) Do what you did before. Shows us the content of the steps in your reply. > > Rich > > -- Adrian Klaver adrian.klaver@aklaver.com