Re: Problem between inheritance and references

From: Stephane Bortzmeyer <bortzmeyer(at)nic(dot)fr>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: Stephane Bortzmeyer <bortzmeyer(at)nic(dot)fr>, pgsql-general(at)postgresql(dot)org
Subject: Re: Problem between inheritance and references
Date: 2002-07-23 15:43:40
Message-ID: 20020723154340.GA30519@nic.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jul 23, 2002 at 08:11:30AM -0700,
Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)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)?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Daryl Beattie 2002-07-23 16:00:36 Auto DROP SEQUENCE?
Previous Message Josh Berkus 2002-07-23 15:37:23 Re: Editor for pgsql