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