Re: BUG #3933: Update problem for 3 Foreign Keys referencing 1 field in another table (I'm not newbie in using SQL)

irfin wrote:
> The following bug has been logged online:
>
> Bug reference: 3933
> Logged by: irfin
> Email address: irfin(at)latifolia(dot)com
> PostgreSQL version: 8.2.3
> Operating system: Windows XP Professional Service Pack 2 (i586)
> Description: Update problem for 3 Foreign Keys referencing 1 field in
> another table (I'm not newbie in using SQL)
> Details:
>
> Dear PostgreSQL Developer Team,
>
> Here's the problem, which I think might be a bug: I have three foreign keys
> and those keys refer to a primary key of another table. When the primary key
> of another table is updated then Postgre raise an error (contraint failed).
> But this problem won't happen if I only have two foreign keys.

Please upgrade to the latest 8.2.X minor release, which is 8.2.6 at the
moment (8.3.0 was just announced as well, BTW, you might want to go
straight to that). I believe this was fixed in 8.2.5.

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com