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/hasconsidered 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
TODOlist 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
severaltables.
>
> 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