Thread: Multi-Table Indexes

Multi-Table Indexes

From
"Benjamin Minshall"
Date:
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



Re: Multi-Table Indexes

From
Bruce Momjian
Date:
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@postgresql.org)
> 

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