Re: Transaction and SQL errors

From: "J(dot) Roeleveld" <joost(at)antarean(dot)org>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Transaction and SQL errors
Date: 2022-04-04 13:26:40
Message-ID: 1824160.tdWV9SEqCh@iris
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)flaesch(at)4js(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2022-04-04 13:47:12 Re: Transaction and SQL errors
Previous Message J. Roeleveld 2022-04-04 13:21:07 Re: Select .... where id not in (....) returns 0 incorrectly