From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Transaction issue |
Date: | 2024-06-20 15:30:00 |
Message-ID: | 9cd4bdb6-5585-c46-83db-ab164513bda0@appl-ecosys.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Shenavai, Manuel | 2024-06-20 16:46:49 | Autovacuum, dead tuples and bloat |
Previous Message | Drew Zoellner | 2024-06-20 15:15:58 | Replication using mTLS issue |