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
