Re: [BUGS] BUG #6748: sequence value may be conflict in some cases

2012-07-23 Thread Tom Lane
meixiangm...@huawei.com writes: > [ freshly-created sequence has wrong state after crash ] I didn't believe this at first, but sure enough, it fails just as described if you force a crash between the first and second nextval calls for the sequence. This used to work ... The change that broke it

[BUGS] BUG #6748: sequence value may be conflict in some cases

2012-07-22 Thread meixiangming
The following bug has been logged on the website: Bug reference: 6748 Logged by: Xiangming Mei Email address: meixiangm...@huawei.com PostgreSQL version: 9.1.4 Operating system: SUSE 11 X64 Description: Reproduce steps: 1. create a table using serial such as: CREATE T