Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 60CA763334F for ; Fri, 4 Dec 2009 13:25:02 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 21227-08 for ; Fri, 4 Dec 2009 17:24:50 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-yw0-f196.google.com (mail-yw0-f196.google.com [209.85.211.196]) by mail.postgresql.org (Postfix) with ESMTP id 868A5632FCA for ; Fri, 4 Dec 2009 13:24:51 -0400 (AST) Received: by ywh34 with SMTP id 34so2433571ywh.1 for ; Fri, 04 Dec 2009 09:24:50 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:date:message-id:subject :from:to:content-type; bh=zzAeuL8rCc0hFwYxqGTTDcK4p7meGmq3u+iFhRd1KLE=; b=UJSYJ/9Lq/6WjzzdgZM/PUvG6qzwybNGO+yfISNInwsPpFa5hrCrexKYbRfP4y/+ve f1ugqbsFMLPVo1P++0hCod+Ahm00bKVWVIySA5PraHxvurP/kvGuNOdcbOVKHzQKcXdu MYC4TblJsntCR5G7TVqKBykn7ONeLBiduTEUk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=Wv/YFp9yBC+BRJejamfeDz7W9aTOy5Y317oZsJLe+7k84C601FQ9+pOt2xjWuAxYxW kaFUA2o/pejA01NSVQOKQ4T9+ZdoYCZyLcjUqFcRjrP79oI0/L8tWNOmgfZOn/ndOPAn cvdtYaxozrrphvZh9Bty/9TvOiRdvqOagLot4= MIME-Version: 1.0 Received: by 10.91.19.15 with SMTP id w15mr5328709agi.12.1259947490087; Fri, 04 Dec 2009 09:24:50 -0800 (PST) Date: Fri, 4 Dec 2009 14:24:49 -0300 Message-ID: Subject: Getting more than one row in UNIQUE fields From: Another Trad To: pgsql-sql@postgresql.org Content-Type: multipart/alternative; boundary=001485f94df095921c0479ea62fd X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.408 tagged_above=-10 required=5 tests=AWL=-0.299, BAYES_05=-1.11, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200912/8 X-Sequence-Number: 33446 --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!!!! 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 number of objects updated 1" But the field client_id is unique and has a sequence to auto increment. Anyone ever pass to this? --001485f94df095921c0479ea62fd Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable My table 'client' has the unique 'client_id'.
My test se= rver, when I try:
se= lect * from client where client_id =3D 12
My server returns 3 row= s!!!!
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 number of objects updated 1"
But the field client_id is u= nique and has a sequence to auto increment.

Anyone ever pass to this?
--001485f94df095921c0479ea62fd--