Christopher Kings-Lynne wrote:
> > 1. The current implementation is broken.
> >
> > 2. We have no proper description of how a "fixed" implementation
> > should work.
>
> Surely 99% of the implementation problems could be solved with an index type
> that can span tables?
Right. Instead of talking in circles, let's figure out how to do it.
If the issue is only sequence numbers, can we force a column to _only_
get values from the sequence counter, thereby makeing the index span
unnecessary? Can't we look up stuff in parent/child index to check for
collisions before we add a row? Doesn't seem too hard to me.
-- 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