From: chester c young <chestercyoung@yahoo.com>
To: Pgsql-sql@postgresql.org <Pgsql-sql@postgresql.org>
Subject: deferrable on unique
Date: Tue, 22 Nov 2005 08:15:24 -0800 (PST)
Message-ID: <20051122161524.10090.qmail@web54309.mail.yahoo.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: chestercyoung@yahoo.com
Subject: Re: deferrable on unique
In-Reply-To: <20051122161524.10090.qmail@web54309.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox