Quick Links

Re: Transaction and SQL errors

From:	David Rowley <dgrowleyml(at)gmail(dot)com>
To:	Sebastien Flaesch <sebastien(dot)flaesch(at)4js(dot)com>
Cc:	"pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject:	Re: Transaction and SQL errors
Date:	2022-04-04 11:44:40
Message-ID:	CAApHDvpz8HohzRpPq3OPkyS3=wV2aQPmE72O3i5D5RbVXehSzA@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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

In response to

Transaction and SQL errors at 2022-04-04 11:33:14 from Sebastien Flaesch

Responses

Re: Transaction and SQL errors at 2022-04-04 12:41:36 from Sebastien Flaesch
Re: Transaction and SQL errors at 2022-04-04 13:26:40 from J. Roeleveld

Browse pgsql-general by date

	From	Date	Subject
Next Message	J. Roeleveld	2022-04-04 12:08:27	Select .... where id not in (....) returns 0 incorrectly
Previous Message	Karsten Hilbert	2022-04-04 11:37:13	Re: Transaction and SQL errors