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 TABLE tbl_aaa ( sno serial NOT NULL, //自增序列，等同于sequence userid int NOT NULL, CONSTRAINT tbl_aaa_pkey PRIMARY KEY (sno) ); 2. insert a tuple: INSERT INTO tbl_aaa values (DEFAULT, 1); 3. postgersql instance crashed, may be power lost or killed by someone: 4. restart the instance then insert another tuple into tbl_aaa, you will get a error message: INSERT INTO tbl_aaa values (DEFAULT, 2); ERROR: SQLSTATE 23505: duplicate key value violates unique constraint "tbl_aaa_pkey" LOCATION: _bt_check_unique, nbtinsert.c:300 I think this is because there is no logit when 'is_called' become from 'f' to 't'. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
