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

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

2008-01-21 Thread Adriaan van Os
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:Multiple UPDATE doesn't handle UNIQUE constraint correctly Details: Suppose