BUG #2734: Primary Key field duplicate value

From: "Wagner Cipriano" <wagnerbhbr(at)yahoo(dot)com(dot)br>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2734: Primary Key field duplicate value
Date: 2006-11-03 15:38:25
Message-ID: 200611031538.kA3FcP0G095051@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 2734
Logged by: Wagner Cipriano
Email address: wagnerbhbr(at)yahoo(dot)com(dot)br
PostgreSQL version: 8.0
Operating system: linux SUSE Kernel 2.6.13.3
Description: Primary Key field duplicate value
Details:

I Have a table 'cliente' with field PK(Primary Key) 'id_cliente' and this
field duplicate values!
Like this:

CRMNEW2=# select id_cliente, count(*) as qde from cliente group by
id_cliente having count(*) > 1;
id_cliente | qde
------------+-----
39832 | 2
40886 | 2
93733 | 2
...

Can I submit file with print screms ?
I want do this.

(Sorry for my english)

Thanks!

Browse pgsql-bugs by date

  From Date Subject
Next Message Andreas Lange 2006-11-03 16:00:23 Re: 8.2bet2 failed build on Solaris 10 / x86-64 / SUN Studio
Previous Message Andreas Lange 2006-11-03 15:29:44 Re: 8.2bet2 failed build on Solaris 10 / x86-64 / SUN Studio