Multi-Table Indexes

Lists: pgsql-hackers
From: "Benjamin Minshall" <minshall(at)intellicon(dot)biz>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Multi-Table Indexes
Date: 2003-06-13 19:34:04
Message-ID: HCECLGBPPGLHHAFMDHPAEEFBCAAA.minshall@intellicon.biz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Greetings Hackers-

I have an interest in developing better OO support in PostgreSQL, and have
done some preliminary research in the archives and TODO list. It appears
that this topic hasn't gotten much traffic in a while, so I thought I'd test
the waters. What do the gurus here think of implementing multi-table
indexes as a vehicle toward better inheritance of keys? Perhaps someone
here who is more familiar with the code tree can comment on the magnitude of
this addition.

Thanks,
-Ben Minshall


From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Benjamin Minshall <minshall(at)intellicon(dot)biz>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Multi-Table Indexes
Date: 2003-06-16 17:28:29
Message-ID: 200306161728.h5GHSTk07462@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers


Seems multi-table indexes are the only solution for various inheritance
problems, and I seem to remember even a non-inheritance case that could
use it, but I can't remember what it was.

---------------------------------------------------------------------------

Benjamin Minshall wrote:
> Greetings Hackers-
>
> I have an interest in developing better OO support in PostgreSQL, and have
> done some preliminary research in the archives and TODO list. It appears
> that this topic hasn't gotten much traffic in a while, so I thought I'd test
> the waters. What do the gurus here think of implementing multi-table
> indexes as a vehicle toward better inheritance of keys? Perhaps someone
> here who is more familiar with the code tree can comment on the magnitude of
> this addition.
>
> Thanks,
> -Ben Minshall
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073