Received: from cryanpc.us.greatbridge.com (cryanpc.us.greatbridge.com [65.196.69.72]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4GCiNA57731 for ; Wed, 16 May 2001 08:44:23 -0400 (EDT) (envelope-from chris@greatbridge.com) Received: from greatbridge.com (IDENT:ryan@database [127.0.0.1]) by cryanpc.us.greatbridge.com (8.11.0/8.11.0) with ESMTP id f4GCjbY08707 for ; Wed, 16 May 2001 08:45:37 -0400 Message-ID: <3B027670.81BC61BC@greatbridge.com> Date: Wed, 16 May 2001 08:45:36 -0400 From: Chris Ryan Reply-To: gorefest@ossi.fho-emden.de Organization: GreatBridge LLC X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.2.17-8smp i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: [Fwd: [Gborg-bugs] BUG: reference error when using inherited tables (ID: 269) (new)] Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200105/158 X-Sequence-Number: 2975 I received this bug on a project I administer that Isn't related to my project. I forwarded it here to see if any of you could help this person. gorefest@ossi.fho-emden.de wrote: > > Title: reference error when using inherited tables > Bug Type: Software bug > Severity: Serious > Software Version: Other > Environment: k6III-500/394 > SuSE 7.1 > Postgres 7.1 > > Created By: gorefest > Description: Hi > > I have a problem with inherited refences. > For example : > CREATE TABLE A(LNR integer Primary key blabla); > CREATE TABLE B () INHERITS(A); > CREATE TABLE C(LNR integer primary key blabla, RNR Intger not null, unique(RNR), FOREIGN KEY(RNR) REFERENCES A.LNr ON DELETE CASCADE); > > will throw an error, if i try to insert an object into B with a counterpart in C. A with a counterpart in C works. Due to the fact, that the inheritance is an acyclic graph, the machine should look in B to. But i get a reference error instead. Are references on inherited tables not implemented yet ? > > greetings gorefest > Status: Submitted > > http://www.greatbridge.org/project/gborg/bugs/bugupdate.php?269 > > _______________________________________________ > Gborg-bugs mailing list > Gborg-bugs@greatbridge.org > http://www.greatbridge.org/mailman/listinfo/gborg-bugs