Horton

Re: Inheritance

Bruce Momjian <pgman@candle.pha.pa.us>

View thread
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Cc: Curt Sampson <cjs@cynic.net>, Don Baccus <dhogaza@pacifier.com>, Lamar Owen <lamar.owen@wgcr.org>, Greg Copeland <greg@CopelandConsulting.Net>, PostgresSQL Hackers Mailing List <pgsql-hackers@postgresql.org>
Date: 2002-08-14T04:44:39Z
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@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