Hi guys,

Wasn't sure if this is a valid idea, but Bruce's response made me think it was worth forwarding here to see if anyone had/has considered it before.

As everyone is aware, I'm not up for coding it, but am mentioning it Just In Case it's deemed worthy of adding to the TODO list in case someone wants to pick up.

:-)

Regards and best wishes,

Justin Clift


-------- Original Message --------
Subject: Re: Interesting thought....
Date: Mon, 21 Jul 2003 14:13:49 -0400 (EDT)
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Justin Clift <justin@postgresql.org>


This would fix all our inheritance problems, and allow sequences to span
multiple tables with an index constraint

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

Justin Clift wrote:
> Hi Bruce,
> 
> Here's an interesting thought....
> 
> Multi-table indexes... like multi-column, but instead of specifying columns in one table, they specify columns in several tables.
> 
> That leads into thoughts about multi-table primary and secondary keys and multi-table foreign keys too.
> 
> Wonder if it'd be useful in the real world?  I reckon so.
> 
> :-)
> 
> Regards and best wishes,
> 
> Justin Clift
> 
> 

-- 
   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, Pennsylvania 19073


Tue, 22 Jul 2003 10:12:30 +0800
Justin Clift <justin@postgresql.org>
[Fwd: Re: Interesting thought....]