| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
| Cc: | Curt Sampson <cjs(at)cynic(dot)net>, Don Baccus <dhogaza(at)pacifier(dot)com>, Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>, Greg Copeland <greg(at)CopelandConsulting(dot)Net>, PostgresSQL Hackers Mailing List <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Inheritance |
| Date: | 2002-08-14 04:44:39 |
| Message-ID: | 200208140444.g7E4idC28734@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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(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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Conway | 2002-08-14 04:45:37 | Re: Open 7.3 items |
| Previous Message | Curt Sampson | 2002-08-14 04:43:43 | Re: Inheritance |