The following bug has been logged online:
Bug reference: 5495
Logged by: Martin Edlman
Email address: edl...@fortech.cz
PostgreSQL version: 8.4.4
Operating system: Scientific Linux 5.5 (RHEL)
Description:RI/FK on self and inherited table
Details:
I have a table
Martin Edlman edl...@fortech.cz writes:
[ FK doesn't see a key that is present in a child table ]
That's how FK checks work, see the Caveats section at the bottom of
http://www.postgresql.org/docs/8.4/static/ddl-inherit.html
regards, tom lane
--
Sent via pgsql-bugs
Martin Edlman edl...@fortech.cz wrote:
ERROR: insert or update on table device violates foreign key
constraint device_parent_id_fkey
DETAIL: Key (parent_id)=(19947) is not present in table device.
But the record is there, it was inserted into net.computer so it's
selectable from