foreign key validation error message

From: Markus Bertheau <twanger(at)bluetwanger(dot)de>
To: PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: foreign key validation error message
Date: 2004-11-01 14:38:19
Message-ID: 1099319899.2640.8.camel@dicaprio.akademie1.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,

I just got the following on 7.4:

oocms=# delete from objects where object_id = 3993;
ERROR: update or delete on "objects" violates foreign key constraint "$1" on "object_as_xml"
DETAIL: Key (object_id)=(3993) is still referenced from table "object_as_xml".

So, there you go:

oocms=# delete from object_as_xml where object_id = 3993;
ERROR: связь "object_as_xml" не существует

(relation "object_as_xml" does not exist)

object_as_xml is in a schema that's not in the search path. The error
message for the foreign key violation should include the schema of the
involved relation.

--
Markus Bertheau <twanger(at)bluetwanger(dot)de>

Browse pgsql-bugs by date

  From Date Subject
Next Message Richard Huxton 2004-11-01 15:00:01 Re: possible bug using combination of 'serial' and rule
Previous Message Silvio Scarpati 2004-11-01 13:34:11 Re: minor issue in createdb 8.0.0beta4