[BUGS] primary and hot standby database don' work now

2012-07-22 Thread leo xu
hello everyone: my pg version is 9.1.2 running on red hat 5.4 x64 servers.one day,i found all database indexes can't work,reindex database,it can work,but some table has primary key,found exists the same two records in table. primary database error:

[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

[BUGS] Duplicate rows primary key bug

2012-07-22 Thread leo xu
version - PostgreSQL 9.1.2 on red hat 5.4 x64, compiled by GCC 4.1 There are several tables have two same rows with the same primary key. This shouldn't happen. Has this been reported as a bug in this version? -- View this

Re: [BUGS] Duplicate rows primary key bug

2012-07-22 Thread Pavel Stehule
Hello 2012/7/23 leo xu : > version > - > PostgreSQL 9.1.2 on red hat 5.4 x64, compiled by GCC 4.1 > > > There are several tables have two same rows with the same primary key. This > shouldn't happen. Has this been reported as a bu