Re: Persistent changes in rolled-back transactions - Mailing list pgsql-admin

From David G. Johnston
Subject Re: Persistent changes in rolled-back transactions
Date
Msg-id CAKFQuwYScf5K8TJ80C4iohDPdyKrjDNbPqwHTNn-xu=kgUtjWQ@mail.gmail.com
Whole thread Raw
In response to Re: Persistent changes in rolled-back transactions  (Wells Oliver <wells.oliver@gmail.com>)
Responses Re: Persistent changes in rolled-back transactions
Re: Persistent changes in rolled-back transactions
List pgsql-admin
On Wed, Nov 9, 2022 at 6:19 PM Wells Oliver <wells.oliver@gmail.com> wrote:
Why do you say truncate is non-transactional? Something simple proves that it's not?

Or just read the documentation for the current version (I seem to recall it used to be non-transactional, maybe...doesn't matter now).

Sequences really shouldn't have been a surprise given the great lengths we go to document their gap-ful nature and this property.

Most anything a typical user is going to do within a SQL transaction is going to either be transactional or it will be disallowed to execute said command within a transaction.

David J.

pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Persistent changes in rolled-back transactions
Next
From: Wael Khobalatte
Date:
Subject: Re: Persistent changes in rolled-back transactions