Re: Persistent changes in rolled-back transactions

From: Wael Khobalatte <wael(at)vendr(dot)com>
To: Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Persistent changes in rolled-back transactions
Date: 2022-11-10 01:16:33
Message-ID: CAJZ8yoZvQ7C5j6d+HnQ4aj=nq0R1LA_mLwKcFNcN2yJc=YxWFQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> I've noticed serials still maintain incremented values even when a
transaction is rolled back. Are there other similar persistent changes to
be aware of?

Postgres sequences (what backs the serial type) are non-transactional.
nextval, setval, et al. Truncate is also non-transactional.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Wells Oliver 2022-11-10 01:18:54 Re: Persistent changes in rolled-back transactions
Previous Message Wells Oliver 2022-11-10 01:07:14 Persistent changes in rolled-back transactions