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

From Wael Khobalatte
Subject Re: Persistent changes in rolled-back transactions
Date
Msg-id CAJZ8yoZvQ7C5j6d+HnQ4aj=nq0R1LA_mLwKcFNcN2yJc=YxWFQ@mail.gmail.com
Whole thread Raw
In response to 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
> 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. 

pgsql-admin by date:

Previous
From: Wells Oliver
Date:
Subject: Persistent changes in rolled-back transactions
Next
From: Wells Oliver
Date:
Subject: Re: Persistent changes in rolled-back transactions