Re: [BUGS] BUG #8382: Duplicate primary key

2013-08-14 Thread Curd Reinert
gsst...@gmail.com schrieb am 14.08.2013 12:44:40: > select ctid,xmin,xmax,primarykey from tab where primarykey = 'duplicatevalue' traviclinkengine=# select ctid,xmin,xmax,* from cluster_ressource where clusterknoten_id = 1 and ressource_id = 10; ctid | xmin| xmax | clusterknoten_id | ress

Re: [BUGS] BUG #8382: Duplicate primary key

2013-08-14 Thread Greg Stark
On Tue, Aug 13, 2013 at 2:50 PM, wrote: > I do have a copy of the data directory with a duplicate row in > cluster_ressource, in case anyone wants to dive into it. Could you run the following? select ctid,xmin,xmax,primarykey from tab where primarykey = 'duplicatevalue' And also show the \d ta

Re: [BUGS] BUG #8382: Duplicate primary key

2013-08-14 Thread Curd Reinert
Hello Greg, gsst...@gmail.com schrieb am 13.08.2013 19:50:35: > The current bug-fix release for Postgres 9 is 9.0.13. There was an > extremely high profile security vulnerability fixed in 9.0.13 so I > would strongly recommend updating. Yes, I noticed that one. However, those installations are not

Re: [BUGS] BUG #8382: Duplicate primary key

2013-08-13 Thread Greg Stark
On Tue, Aug 13, 2013 at 2:50 PM, wrote: > The following bug has been logged on the website: > > Bug reference: 8382 > Logged by: Curd Reinert > Email address: curd.rein...@ppi.de > PostgreSQL version: 9.0.5 The current bug-fix release for Postgres 9 is 9.0.13. There was an ext

[BUGS] BUG #8382: Duplicate primary key

2013-08-13 Thread curd . reinert
The following bug has been logged on the website: Bug reference: 8382 Logged by: Curd Reinert Email address: curd.rein...@ppi.de PostgreSQL version: 9.0.5 Operating system: Windows Server 2013 Description: One of our customers encounters a problem because some tables