Re: [BUGS] BUG #2511: violation of primary key on update with 2

2006-07-03 Thread Simon Riggs
On Mon, 2006-07-03 at 11:14 +, james wrote: > i think it's a bug in postgresql ... Primary Key constraints are not deferrable currently. This is a known situation so this isn't a bug. I would advise you not to update the PK of your tables. That usually represents a modelling problem and so I

[BUGS] BUG #2511: violation of primary key on update with 2 tables

2006-07-03 Thread james
The following bug has been logged online: Bug reference: 2511 Logged by: james Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.1 Operating system: windows xp professional sp2 Description:violation of primary key on update with 2 tables Details: hi, i've tr