The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/sql-droppublication.html
Description:
Hi,
I'm using a lot the logical replication.
I have to do some DDL changes, via an automatic process, on the primary.
That process drop the existing p
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
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 relinquish
any locks and predicate locks early, or will it
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
