Re: Transaction issue - Mailing list pgsql-general

From Rob Sargent
Subject Re: Transaction issue
Date
Msg-id 393A432B-E08C-46C6-B8FE-BE20BEE4E122@gmail.com
Whole thread Raw
In response to Re: Transaction issue  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: Transaction issue
List 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
>
>



pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Transaction issue
Next
From: Rich Shepard
Date:
Subject: Re: Transaction issue