Postgres Pro
Downloads
Home   >   mailing lists

Re: Sequence's value can be rollback after a crashed recovery. - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: Sequence's value can be rollback after a crashed recovery.
Date
Msg-id CAKFQuwZCRFzyF4ys9u9d5ZcHfF3bZGWoTLV4BLDHSCnr+GY_dA@mail.gmail.com
Whole thread Raw
In response to Sequence's value can be rollback after a crashed recovery.  (Andy Fan <zhihui.fan1213@gmail.com>)
List pgsql-hackers
Tree view
On Sunday, November 21, 2021, Andy Fan <zhihui.fan1213@gmail.com> wrote:
Should we guarantee the sequence's nextval should never be rolled back
even in a crashed recovery case?
I can produce the rollback in the following case:

This seems to be the same observation that was made a little over a year ago.


I don’t think the suggested documentation ever got written but haven’t looked for it either.

David J.

pgsql-hackers by date:

Previous
From: Richard Guo
Date:
Subject: Re: A problem about partitionwise join
Next
From: Andy Fan
Date:
Subject: Re: Keep notnullattrs in RelOptInfo (Was part of UniqueKey patch series)