Re: foreign key constraints and inheritence

From: "Sander Steffann" <steffann(at)nederland(dot)net>
To: "Michael Fuhr" <mike(at)fuhr(dot)org>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: foreign key constraints and inheritence
Date: 2005-07-17 20:33:58
Message-ID: 000301c58b0e$dc6162e0$64c8a8c0@balefirehome
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jim C. Nasby 2005-07-17 22:47:37 Re: Converting MySQL tinyint to PostgreSQL
Previous Message Harry Mantheakis 2005-07-17 20:28:30 Re: Japanese words not distinguished - Solution