On Wed, 2025-05-28 at 11:09 -0400, Dave Cramer wrote:
> Somewhat annoying feature of this behaviour is that when COMMIT is issued on
> an aborted transaction no error is reported.
> Most drivers work around this problem by keeping track of the previous error
> and reporting an error on the COMMIT
On Wed, 28 May 2025 at 10:59, David G. Johnston
wrote:
> On Wed, May 28, 2025 at 7:47 AM mark maker wrote:
>
>> Wow, great improvement, thanks!
>>
>> The "tutorial-transactions" opens a new question that might be useful to
>> know: when a transaction enters the aborted state at an early point in
y, or will it still hold onto those
until explicitly rolled back by command?
_Mark
*From:* David G. Johnston
*Sent:* Wednesday, May 28, 2025 at 4:04 PM UTC+2
*To:* Laurenz Albe
*Cc:* m...@makr.zone , pgsql-docs@lists.postgresql.org
*Subject:* RE: Documentation should state what happe
On Wed, May 28, 2025 at 7:47 AM mark maker wrote:
> Wow, great improvement, thanks!
>
> The "tutorial-transactions" opens a new question that might be useful to
> know: when a transaction enters the aborted state at an early point in time
> (as has now become clear), does this mean it will also r
On Wednesday, May 28, 2025, Laurenz Albe wrote:
> On Wed, 2025-05-28 at 08:08 +, PG Doc comments form wrote:
> > The following documentation comment has been logged on the website:
> >
> > Page: https://www.postgresql.org/docs/17/sql-commit.html
> > Description:
> >
> > Deferrable constraints
On Wed, 2025-05-28 at 08:08 +, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/17/sql-commit.html
> Description:
>
> Deferrable constraints, deadlocks and possibly other deferred or lazily
> evaluated
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/17/sql-commit.html
Description:
Deferrable constraints, deadlocks and possibly other deferred or lazily
evaluated rules are checked upon commit.
What happens if they are not met and the commi
