Re: [SQL] Getting more than one row in UNIQUE fields

2009-12-06 Thread Jasen Betts
On 2009-12-04, Another Trad wrote: > --001485f94df095921c0479ea62fd > Content-Type: text/plain; charset=ISO-8859-1 > > 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 I had similar with a client

Re: [SQL] Getting more than one row in UNIQUE fields

2009-12-04 Thread Tom Lane
Another Trad 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? regard

[SQL] Getting more than one row in UNIQUE fields

2009-12-04 Thread Another Trad
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 When I try to update this client, his name for example,using my framework (SQLAlchemy), obviously returns the error: "Updated rowcount 3 does not match nu