Re: foreign key constraints and inheritence - Mailing list pgsql-general

From Michael Fuhr
Subject Re: foreign key constraints and inheritence
Date
Msg-id 20050717141248.GB9637@winnie.fuhr.org
Whole thread Raw
In response to Re: foreign key constraints and inheritence  ("Sander Steffann" <steffann@nederland.net>)
List 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/

pgsql-general by date:

Previous
From: ptjm@interlog.com (Patrick TJ McPhee)
Date:
Subject: Re: How to create unique constraint on NULL columns
Next
From: Martijn van Oosterhout
Date:
Subject: Re: (Win32 Postgres) Slow to Connect first - OK afterwards