Re: BUG #3455: order of rows should not significant - Mailing list pgsql-bugs

"YaYo" <yayooo@gmail.com> writes:

> test=# select * from t9;
> var
> -----
> 3
> 5
> (2 rows)
>
> test=# update t9 set var=var+2;
> ERROR: duplicate key violates unique constraint "t9_var_key" /*we get the
> same conclusion*/

Sorry, Postgres does not support deferred unique constraints which is what you
would need to get this to work. This is a TODO item but nobody has indicated
they wish to (or know how to) do it yet.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com