Re: Persistent changes in rolled-back transactions

Поиск
Список
Период
Сортировка
От Wael Khobalatte
Тема Re: Persistent changes in rolled-back transactions
Дата
Msg-id CAJZ8yoZvQ7C5j6d+HnQ4aj=nq0R1LA_mLwKcFNcN2yJc=YxWFQ@mail.gmail.com
обсуждение исходный текст
Ответ на Persistent changes in rolled-back transactions  (Wells Oliver <wells.oliver@gmail.com>)
Ответы Re: Persistent changes in rolled-back transactions
Re: Persistent changes in rolled-back transactions
Список 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 по дате отправления: