Re: Transaction issue

Rob Sargent <robjsargent@gmail.com>

From: Rob Sargent <robjsargent@gmail.com>
To: Rich Shepard <rshepard@appl-ecosys.com>
Cc: pgsql-general@lists.postgresql.org, pgsql-general@postgresql.org
Date: 2024-06-20T14:41:00Z
Lists: pgsql-general

> On Jun 20, 2024, at 7:05 AM, Rich Shepard <rshepard@appl-ecosys.com> wrote:
> 
> On Thu, 20 Jun 2024, Karsten Hilbert wrote:
> 
>> Shot in the dark: are you be any chance using tab-completion
>> when running the SELECT before the COMMIT ?
> 
> Karsten,
> 
> Nope. I prepare DDL, DML, and DQL scripts in emacs, then run them from the
> psql prompt using \i <filename>.
> 

Is psql running in emacs (which is my preferred sql shell. M-x sql-postgres)?

Also change all semi-colons to \p\g to confirm the error location.  Maybe trap the output

> Regards,
> 
> Rich
> 
>