Alban Hertroys wrote:
Naz Gassiep wrote:
Hi,
I'm trying to do an update on a table that has a unique constraint
on the field, I need to update the table by setting field = field+1
I think you're looking for deferrable constraints; see:
http://www.postgresql.org/docs/8.2/static/sql-set-constraints.html
Which won't work with unique constraints unfortunately. That's because
they're implemented through a unique index.
The work-around is to do: field = -field then field = -field + 1 or similar.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
