Postgres Pro
Downloads
Home   >   mailing lists

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

From David Rowley
Subject Re: Transaction and SQL errors
Date
Msg-id CAApHDvpz8HohzRpPq3OPkyS3=wV2aQPmE72O3i5D5RbVXehSzA@mail.gmail.com
Whole thread Raw
In response to Transaction and SQL errors  (Sebastien Flaesch <sebastien.flaesch@4js.com>)
Responses Re: Transaction and SQL errors
Re: Transaction and SQL errors
List pgsql-general
Tree view 
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

pgsql-general by date:

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