"YaYo" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
