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

From Another Trad
Subject Getting more than one row in UNIQUE fields
Date
Msg-id af7271950912040924y6c5146bet1b043f608a764646@mail.gmail.com
Whole thread Raw
Responses Re: Getting more than one row in UNIQUE fields  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
My table 'client' has the unique 'client_id'.<br />My test server, when I try:<br /><span style="font-family: courier
new,monospace;">select* from client where client_id = 12</span><br />My server returns 3 rows!!!!<br /> When I try to
updatethis client, his name for example,using my framework (SQLAlchemy), obviously returns the error:<br />"Updated
rowcount3 does not match number of objects updated 1"<br />But the field client_id is unique and has a sequence to auto
increment.<br/><br />Anyone ever pass to this?<br /> 

pgsql-sql by date:

Previous
From: Uwe Maiwald
Date:
Subject: get sequence name from table name
Next
From: Tom Lane
Date:
Subject: Re: Getting more than one row in UNIQUE fields