Re: foreign key constraints and inheritence

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Sander Steffann <steffann(at)nederland(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: foreign key constraints and inheritence
Date: 2005-07-17 14:12:48
Message-ID: 20050717141248.GB9637@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, Jul 17, 2005 at 12:38:48PM +0200, Sander Steffann wrote:
> >
> >"A serious limitation of the inheritance feature is that indexes
> >(including unique constraints) and foreign key constraints only
> >apply to single tables, not to their inheritance children. This
> >is true on both the referencing and referenced sides of a foreign
> >key constraint."
>
> I would realy like to see this fixed. But I guess if it was easy then
> someone would already have fixed it...

It's on the developers' TODO list. I'm sure a patch would be welcome :-)

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2005-07-17 14:53:25 Re: (Win32 Postgres) Slow to Connect first - OK afterwards
Previous Message Garrett Kalleberg 2005-07-17 12:59:43 Re: foreign key constraints and inheritence