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 > >