Re: Transaction and SQL errors - Mailing list pgsql-general

From J. Roeleveld
Subject Re: Transaction and SQL errors
Date
Msg-id 1824160.tdWV9SEqCh@iris
Whole thread Raw
In response to Re: Transaction and SQL errors  (David Rowley <dgrowleyml@gmail.com>)
List pgsql-general
On Monday, April 4, 2022 1:44:40 PM CEST David Rowley wrote:
> On Mon, 4 Apr 2022 at 23:33, Sebastien Flaesch
> 
> <sebastien.flaesch@4js.com> wrote:
> > Any arguments I could give to programmers?   Maybe:
> > "You better replay all SQL of the whole transaction... (and make them as
> > short as possible!)" ?
> 
> There are SAVEPOINTs [1].
> 
> David
> 
> [1] https://www.postgresql.org/docs/current/sql-savepoint.html

Thank you! :)
I wasn't aware of this yet, but it will make some of my code easier to read .

--
Joost





pgsql-general by date:

Previous
From: "J. Roeleveld"
Date:
Subject: Re: Select .... where id not in (....) returns 0 incorrectly
Next
From: "David G. Johnston"
Date:
Subject: Re: Transaction and SQL errors