public inbox for [email protected]  
help / color / mirror / Atom feed
From: Rich Shepard <[email protected]>
To: [email protected]
Subject: Re: Transaction issue
Date: Thu, 20 Jun 2024 08:30:00 -0700 (PDT)
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>

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






view thread (3+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: Transaction issue
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox