Re: BUG: RI not enforced on inherited foreign keys (v.7.2.1) - Mailing list pgsql-bugs

From Stephan Szabo
Subject Re: BUG: RI not enforced on inherited foreign keys (v.7.2.1)
Date
Msg-id 20020802112731.S41371-100000@megazone23.bigpanda.com
Whole thread Raw
In response to BUG: RI not enforced on inherited foreign keys (v.7.2.1)  ("Ernest E Vogelsinger" <ernest.vogelsinger@eventus.at>)
List pgsql-bugs
On Fri, 2 Aug 2002, Ernest E Vogelsinger wrote:

> There is a severe problem with foreign keys that are inherited:
> RI is NOT enforced on inherited foreign keys.

This is a known issue with all of foreign keys, unique constraints,
primary keys and triggers.  All of these apply only to the table they're
defined on and in the case of foreign keys to only the table they mention.

pgsql-bugs by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Case bug in SQL Constraint
Next
From: Tom Lane
Date:
Subject: Re: ERROR: scanNameSpaceForRefname: unexpected node type 0