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
