On 2019-06-21 07:31, Michael Paquier wrote: > 1) Some SQL queries: > create unlogged sequence popo; > alter sequence popo increment 2;
The problem is that the above command does a relation rewrite but the code doesn't know to copy the init fork of the sequence. That will need to be addressed. > select nextval('popo'); > select nextval('popo'); > 2) Then a hard crash: > pg_ctl stop -m immediate > pg_ctl start > 3) Again, with a crash: > select nextval('popo'); > > > #2 0x000055ce60f3208d in ExceptionalCondition -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services