Re: Inheritance fixing timeline? (Was "Inherited FK Indexing") - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Inheritance fixing timeline? (Was "Inherited FK Indexing")
Date
Msg-id 20071001163335.GA5914@alvh.no-ip.org
Whole thread Raw
In response to Inheritance fixing timeline? (Was "Inherited FK Indexing")  ("Webb Sprague" <webb.sprague@gmail.com>)
List pgsql-general
Webb Sprague escribió:
> > >   Is it
> > > possible to have  FK that spans into child tables?
> >
> > This is a well known (and documented, see [1]) deficiency. It's due to
> > the current implementation of indices, which are bound to exactly one
> > table, meaning they do return a position within the table, but cannot
> > point to different tables.
>
> Is this set to be fixed in any particular release?

No, sorry.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Inheritance problem when restoring db
Next
From: Nico Sabbi
Date:
Subject: Re: row->ARRAY or row->table casting?