Re: BUG: RI not enforced on inherited foreign keys (v.7.2.1)

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Ernest E Vogelsinger <ernest(dot)vogelsinger(at)eventus(dot)at>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG: RI not enforced on inherited foreign keys (v.7.2.1)
Date: 2002-08-02 18:30:43
Message-ID: 20020802112731.S41371-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2002-08-02 19:35:49 Re: ERROR: scanNameSpaceForRefname: unexpected node type 0
Previous Message Stephan Szabo 2002-08-02 18:26:37 Re: Case bug in SQL Constraint