X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3181CDB0C8 for ; Tue, 22 Nov 2005 12:15:36 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 70855-01 for ; Tue, 22 Nov 2005 16:15:33 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from web54309.mail.yahoo.com (web54309.mail.yahoo.com [206.190.49.119]) by svr1.postgresql.org (Postfix) with SMTP id 0CAF3DB093 for ; Tue, 22 Nov 2005 12:15:32 -0400 (AST) Received: (qmail 10092 invoked by uid 60001); 22 Nov 2005 16:15:24 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=V2l7c11mIoUaC28kqkfTdgK+uzShIFkLYOKkEIwLYOV3S5ipJ4Q/gj3VuK/BaKZfvgI/7E1lPR80JdsnltdCkThfKJQc1Vj2ylsx713l9ADXxAVcFJCqk4mHNOIItm1XkJ9rluT8UYD525RjU9vrLDJ0dJR8Ej30mpOF0PQNU98= ; Message-ID: <20051122161524.10090.qmail@web54309.mail.yahoo.com> Received: from [207.141.5.253] by web54309.mail.yahoo.com via HTTP; Tue, 22 Nov 2005 08:15:24 PST Date: Tue, 22 Nov 2005 08:15:24 -0800 (PST) From: chester c young Subject: deferrable on unique To: "Pgsql-sql@postgresql.org" MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.479 required=5 tests=[DNS_FROM_RFC_ABUSE=0.479] X-Spam-Score: 0.479 X-Spam-Level: X-Archive-Number: 200511/203 X-Sequence-Number: 23454 table t1: id integer primary key, seq integer not null unique the seq is for ordering the rows as the user likes. however, if the rows are moved around, eg begin update t1 set seq=4 where id=5 update t1 set seq=5 where id=4 end will bomb because the first update has two rows of seq=4 (although correct after the transaction). I thought "deferrable initally deferred" would fix this, but the phrase is not allowed on unique. is this correct? any ideas? __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com