Re: effective SELECT from child tables

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: effective SELECT from child tables
Дата
Msg-id 20050928202417.GH2436@svana.org
обсуждение исходный текст
Ответ на Re: effective SELECT from child tables  ("Ilia Kantor" <ilia@obnovlenie.ru>)
Ответы Re: effective SELECT from child tables  ("Jim C. Nasby" <jnasby@pervasive.com>)
Re: effective SELECT from child tables  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-hackers
On Wed, Sep 28, 2005 at 11:00:46PM +0400, Ilia Kantor wrote:
> Your suggestion is essentially the same as mine..
> There exists tableoid, pretty much suited to tell between tables in the case
> of inheritance.. I can't see a "real" need to add a special "class
> classifier" to each table..
> This solution is a workaround. It will work, just can't make myself love it.

I wonder if it would be possible to tweak the constraints exclusion
code so that if it sees something of the form "tableoid = X" to exclude
other tables...

You know, assume each table has a constraint "tableoid = OID".

Still, it is a fairly unusual feature.
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: [DOCS] Added documentation about caching, reliability
Следующее
От: "Marc G. Fournier"
Дата:
Сообщение: Re: Open items list for 8.1