Re: Update violating constraint

Alban Hertroys wrote:
> Richard Huxton wrote:
> > 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.
>
> I appreciate the complexities involved, but that really ought to work on
> a single statement. I recall seeing something along these lines on the
> TODO list some time ago?

It is still on the TODO list.  If you want it to disappear from there,
your best bet is implementing a fix, followed by motivating someone to
do it for you.  If you don't, bets are someone will do it eventually
(which may be too late for your taste).

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support