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 <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1sK0EZ-007o1K-FC
	for pgsql-general@arkaria.postgresql.org; Wed, 19 Jun 2024 18:40:39 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1sK0EX-004ogt-8Z
	for pgsql-general@arkaria.postgresql.org; Wed, 19 Jun 2024 18:40:38 +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 <adrian.klaver@aklaver.com>)
	id 1sK0EW-004ogl-Tb
	for pgsql-general@lists.postgresql.org; Wed, 19 Jun 2024 18:40:37 +0000
Received: from fout3-smtp.messagingengine.com ([103.168.172.146])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <adrian.klaver@aklaver.com>)
	id 1sK0EV-002W64-JB
	for pgsql-general@postgresql.org; Wed, 19 Jun 2024 18:40:37 +0000
Received: from compute5.internal (compute5.nyi.internal [10.202.2.45])
	by mailfout.nyi.internal (Postfix) with ESMTP id C807D1380224;
	Wed, 19 Jun 2024 14:40:32 -0400 (EDT)
Received: from mailfrontend1 ([10.202.2.162])
  by compute5.internal (MEProxy); Wed, 19 Jun 2024 14:40:32 -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=1718822432;
	 x=1718908832; bh=rsrurorAi53SzeH+hzJnHdb+rDNoEQIyrTiCHmC0itc=; b=
	PBcDrGJoQRiYvbyjIvzgABWTIbuen+vxdGvpL1ccIX5WxFDKGPyKDIHdn7eBNvqD
	sE2mni43Y3/zW+tCwes5nHih+KaLHrVktbYs9cqE7aFRDUMYbaGeXPpnaRSZCubq
	jkMBTn0yp0Xp8NOkmEnqb4mAbeDUHpZ5EKDzA1cP2VClewE1HfTZRyvjqO4FloZJ
	CSpiM//LVGgv7VcCrOIpUc+Kodg+kXh2vvaaeJiXOLbD4raOJs5h4M8U5OX9ujjU
	bZ+axw2sOAAsA8lAoJQ/ObeaeVo9H/gYLgWMoM2RIvbI2CiNbhEtsxHzZZa+qK91
	O5AP/7qYOm/R2iz35fCRlQ==
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=1718822432; x=
	1718908832; bh=rsrurorAi53SzeH+hzJnHdb+rDNoEQIyrTiCHmC0itc=; b=H
	lVHmD9lK5spZf93LIvbTDj35hvnZY3NLBJssmfwz8qaYRleqelieo4f07NNTNSy4
	C++vwALabxrOZvfmWa1c0huk8ktX428YczUJj1qhCaNxbEsWaoaN46znVWyiNsVa
	ZHGzZc6yYzSZBVo2wZik+EVYV7Ui5gdmRoQ76OwwNUhxSQLcGgPWRNSnADktE5Ih
	cjlUo6Jl0rQpkB/UjrMhQxrvnZ5gPMMXLP6gItZ5jwKx5ALsGG6mRswelJAdoFOB
	SjYZ4yBqUeQ7HNjB82USwlvjysax4s19ojAeefKEJPe+7xoMm2nnkrLCZNop9SrN
	Ea5naG0vV7S9G7rZpzsdg==
X-ME-Sender: <xms:ICZzZmL5FW0vkFbrhsRER6_PHQAKhTJKOqFN6dvCm-HnDkzBh5lhLQ>
    <xme:ICZzZuJWt1oRD1LLMZ7zLyUZEhe3MjWZDDiuK6LstR-2y0dCIp5B1G1yAi7iCyZUV
    cZ03_IQ6xbkb_o>
X-ME-Received: <xmr:ICZzZmti12Pklbxtnb1Ux_CbDK66Z86XYgioWU5Q-H-MkgL2McMyIN573AKb1nDa2c9zBy6kd3RZzO3TpXQMKjlTJvn1GJ5Orw>
X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvledrfeeftddguddvjecutefuodetggdotefrod
    ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh
    necuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmd
    enucfjughrpefkffggfgfuvfhfhfgjtgfgsehtjeertddtvdejnecuhfhrohhmpeetughr
    ihgrnhcumfhlrghvvghruceorggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtg
    homheqnecuggftrfgrthhtvghrnhepiedvhfeiheehgeeuieeljeeitedtjeehudegfeel
    kedvleekhedtgfeiffefkedunecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpe
    hmrghilhhfrhhomheprggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomh
X-ME-Proxy: <xmx:ICZzZrZ1qM4gWefqjmw8I35cMYxUXrIqdxHHIZIhsbd-cdk4p5h_Ew>
    <xmx:ICZzZtZmh-ulqDAreLuufbfLzANUoc84DWUyYedSTlOQoFqvSPxMNw>
    <xmx:ICZzZnCpOdETkg7TwW2S7kbb_bi4ZwrxXtrFTgUQkrSrmiyDnVGDhA>
    <xmx:ICZzZjZWpam0xYmPwNGHOL7lN4bdRrCVKckk31RFPip7t_9xXAN_fA>
    <xmx:ICZzZsk4DPkqHfkzFPBot42WtNu9cG2a8WOndv7-r_R9xQ6gS0oOtVAi>
Feedback-ID: i76984098:Fastmail
Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed,
 19 Jun 2024 14:40:30 -0400 (EDT)
Message-ID: <b671e9f9-27a8-4901-802a-b256919fc85d@aklaver.com>
Date: Wed, 19 Jun 2024 11:40:29 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Transaction issue
To: Rich Shepard <rshepard@appl-ecosys.com>, pgsql-general@postgresql.org
References: <b77e58b-dd8c-373b-2a25-9eb224488e8b@appl-ecosys.com>
 <4773397e-dec5-4c0a-bbfc-ea5794805c4d@aklaver.com>
 <23351ad6-5a62-64e5-63e-8364b9f4f774@appl-ecosys.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <23351ad6-5a62-64e5-63e-8364b9f4f774@appl-ecosys.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/b671e9f9-27a8-4901-802a-b256919fc85d%40aklaver.com>
Precedence: bulk



On 6/19/24 11:36 AM, Rich Shepard wrote:
> On Wed, 19 Jun 2024, Adrian Klaver wrote:
> 
>> Is this being done in a script fed to psql?
> 
> Adrian,
> 
> Yes. At the psql prompt I use the \i <filename> command to run the script.

Are there transaction statements e.g. BEGIN;, COMMIT; in the script?

> 
> Rich
> 
> 
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com