Re: Transaction issue - Mailing list pgsql-general

From Rich Shepard
Subject Re: Transaction issue
Date
Msg-id 9cd4bdb6-5585-c46-83db-ab164513bda0@appl-ecosys.com
Whole thread Raw
In response to Re: Transaction issue  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
On Thu, 20 Jun 2024, Adrian Klaver wrote:

> From one of my previous posts(modified):
> At this point I think you need to create a simple test case where:
>
> 1) You have script with
> BEGIN;
> <A line that contains the syntax error>
> COMMIT; --optional
>
> 2) In psql do \i <the_script>
>
> 3) Do what you did before to 'recover' from the error.
>
> Shows us the content of the steps in your reply.

Adrian,

I belive that I did this yesterday. Regardless, either leaving off `BEGIN;'
from the top of the script, or entering it prior to running the script,
resolves the issue.

I've not seen a problem since finding the solutions.

Best regards,

Rich



pgsql-general by date:

Previous
From: Drew Zoellner
Date:
Subject: Replication using mTLS issue
Next
From: "Shenavai, Manuel"
Date:
Subject: Autovacuum, dead tuples and bloat