Re: Problem between inheritance and references - Mailing list pgsql-general

From Stephane Bortzmeyer
Subject Re: Problem between inheritance and references
Date
Msg-id 20020723154340.GA30519@nic.fr
Whole thread Raw
In response to Re: Problem between inheritance and references  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Responses Re: Problem between inheritance and references
Re: Problem between inheritance and references
List pgsql-general
On Tue, Jul 23, 2002 at 08:11:30AM -0700,
 Stephan Szabo <sszabo@megazone23.bigpanda.com> wrote
 a message of 16 lines which said:

> The problem is that foreign keys, primary keys, unique constraints,
> and triggers (and maybe other stuff, but at least that) don't
> inherit,

:-( So basically, INHERITS just give you the columns of the parent
table?

> so the foreign key is referencing only the table mentioned.  The
> equivalent select is select * from ONLY Authentication I believe.

OK, I see the problem. Any suggestion on how to rephrase my schema
(besides dropping inheritance)?


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: URGENT! pg_dump doesn't work!
Next
From: Stephan Szabo
Date:
Subject: Re: Problem between inheritance and references