Postgres Pro
Downloads
Home   >   mailing lists

Re: Getting more than one row in UNIQUE fields - Mailing list pgsql-sql

From Tom Lane
Subject Re: Getting more than one row in UNIQUE fields
Date
Msg-id 27055.1259948214@sss.pgh.pa.us
Whole thread Raw
In response to Getting more than one row in UNIQUE fields  (Another Trad <anothertrad@gmail.com>)
List pgsql-sql
Tree view 
Another Trad <anothertrad@gmail.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

pgsql-sql by date:

Previous
From: Another Trad
Date:
Subject: Getting more than one row in UNIQUE fields
Next
From: Gerardo Herzig
Date:
Subject: Re: get sequence name from table name