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

From Sander Steffann
Subject Re: foreign key constraints and inheritence
Date
Msg-id 000301c58b0e$dc6162e0$64c8a8c0@balefirehome
Whole thread Raw
In response to foreign key constraints and inheritence  (Garrett Kalleberg <experimental@metadada.com>)
Responses Re: foreign key constraints and inheritence
List pgsql-general
Hi,

>> >"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 :-)

I wish I knew enough about the internals of PostgreSQL to write one :-)
Sander



pgsql-general by date:

Previous
From: Harry Mantheakis
Date:
Subject: Re: Japanese words not distinguished - Solution
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Converting MySQL tinyint to PostgreSQL