Re: BUG #5495: RI/FK on self and inherited table - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #5495: RI/FK on self and inherited table
Date
Msg-id 24422.1276093925@sss.pgh.pa.us
Whole thread Raw
In response to BUG #5495: RI/FK on self and inherited table  ("Martin Edlman" <edlman@fortech.cz>)
List pgsql-bugs
"Martin Edlman" <edlman@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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bad optimizer data for xml (WAS: xml data type implications of no =)
Next
From: Robert Haas
Date:
Subject: Re: Invalid YAML output from EXPLAIN