Re: Getting more than one row in UNIQUE fields

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Another Trad <anothertrad(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Getting more than one row in UNIQUE fields
Date: 2009-12-04 17:36:54
Message-ID: 27055.1259948214@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Another Trad <anothertrad(at)gmail(dot)com> writes:
> My table 'client' has the unique 'client_id'.
> My test server, when I try:
> select * from client where client_id = 12
> My server returns 3 rows!!!!

We've seen bugs of that sort in the past ... what PG version is this,
and on what platform?

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Gerardo Herzig 2009-12-04 18:02:37 Re: get sequence name from table name
Previous Message Another Trad 2009-12-04 17:24:49 Getting more than one row in UNIQUE fields