Re: Inheritance fixing timeline? (Was "Inherited FK Indexing")

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Webb Sprague <webb(dot)sprague(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Inheritance fixing timeline? (Was "Inherited FK Indexing")
Date: 2007-10-01 16:33:35
Message-ID: 20071001163335.GA5914@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Nico Sabbi 2007-10-01 16:34:59 Re: row->ARRAY or row->table casting?
Previous Message Tom Lane 2007-10-01 16:14:37 Re: Inheritance problem when restoring db