Horton
Menu

Re: Transaction issue

Rich Shepard <rshepard@appl-ecosys.com>

View thread
From: Rich Shepard <rshepard@appl-ecosys.com>
To: pgsql-general <pgsql-general@postgresql.org>
Date: 2024-06-20T13:06:56Z
Lists: pgsql-general 
On Wed, 19 Jun 2024, Ron Johnson wrote:

> In addition, manually run the "BEGIN;" before the "\i insert-blarge.sql"
> command.
>
> That way, insert-blarge.sql just inserts. My reasoning: since you control
> the ROLLBACK, you should also control the BEGIN.

Ron,

Hadn't thought of doing that, but now will. Thanks for the excellent
recomendation.

Regards,

Rich