Re: [BUGS] BUG #3891: Multiple UPDATE doesn't handle UNIQUE constraint correctly

2008-01-21 Thread David Fetter
On Mon, Jan 21, 2008 at 08:17:47AM +, Adriaan van Os wrote: > > The following bug has been logged online: > > Bug reference: 3891 > Logged by: Adriaan van Os > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.2.4 > Operating system: Mac OS X 10.5 > Description:

Re: [BUGS] BUG #3891: Multiple UPDATE doesn't handle UNIQUE constraint correctly

2008-01-21 Thread Euler Taveira de Oliveira
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