Adriaan van Os wrote: > This will cause a UNIQUE violation in de middle of the UPDATE statement, > although after completion of the statement there is no such violation. > This is not a bug. > Although deferred constraints are not yet implemented for Postgres, the docs > at <http://www.postgresql.org/docs/8.2/static/sql-set-constraints.html> > state: > But I forgot to read this: "Check and unique constraints are always effectively not deferrable." It's a known "problem" (TODO item). See Greg's elegant solution [1]. [1] http://people.planetpostgresql.org/greg/index.php?/archives/2006/06/10.html -- Euler Taveira de Oliveira http://www.timbira.com/
pgsql-bugs by date:
Соглашаюсь с условиями обработки персональных данных