Thread: Getting more than one row in UNIQUE fields
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 />
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
On 2009-12-04, Another Trad <anothertrad@gmail.com> 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 on friday, windows event log shouwed disk errors, chkdsk showed damaged database files. I passed the problem back to their IT guy.