Thread

1. INHERITS doesn't offer enough functionality

   Alfred Perlstein <bright@wintelcom.net> — 2000-08-28T19:00:07Z

   I noticed that INHERITS doesn't propogate indecies, It'd be nice
   if there was an toption to do so.
   
   thanks,
   -- 
   -Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
   "I have the heart of a child; I keep it in a jar on my desk."
   
   

2. Re: INHERITS doesn't offer enough functionality

   Chris <chrisb@nimrod.itg.telstra.com.au> — 2000-08-29T00:09:18Z

   Alfred Perlstein wrote:
   > 
   > I noticed that INHERITS doesn't propogate indecies, It'd be nice
   > if there was an toption to do so.
   
   Yep it would. Are you volunteering?
   
   

3. Re: INHERITS doesn't offer enough functionality

   Alfred Perlstein <bright@wintelcom.net> — 2000-08-29T00:20:38Z

   * Chris <chrisb@nimrod.itg.telstra.com.au> [000828 17:15] wrote:
   > Alfred Perlstein wrote:
   > > 
   > > I noticed that INHERITS doesn't propogate indecies, It'd be nice
   > > if there was an toption to do so.
   > 
   > Yep it would. Are you volunteering?
   
   Ha, right now I'm doing a major rewrite of my own code to hack
   around vacuum, it'll have to wait but thanks for the vote of
   confidence. :-)
   
   -- 
   -Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
   "I have the heart of a child; I keep it in a jar on my desk."
   
   

4. Re: INHERITS doesn't offer enough functionality

   Bruce Momjian <pgman@candle.pha.pa.us> — 2000-10-16T15:55:14Z

   > Alfred Perlstein wrote:
   > > 
   > > I noticed that INHERITS doesn't propogate indecies, It'd be nice
   > > if there was an toption to do so.
   > 
   > Yep it would. Are you volunteering?
   > 
   
   Added to TODO:
   
   	* Allow inherited tables to inherit index
   
   -- 
     Bruce Momjian                        |  http://candle.pha.pa.us
     pgman@candle.pha.pa.us               |  (610) 853-3000
     +  If your life is a hard drive,     |  830 Blythe Avenue
     +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
   
   

5. Re: INHERITS doesn't offer enough functionality

   Alfred Perlstein <bright@wintelcom.net> — 2000-10-16T16:42:23Z

   * Bruce Momjian <pgman@candle.pha.pa.us> [001016 08:55] wrote:
   > > Alfred Perlstein wrote:
   > > > 
   > > > I noticed that INHERITS doesn't propogate indecies, It'd be nice
   > > > if there was an toption to do so.
   > > 
   > > Yep it would. Are you volunteering?
   > > 
   > 
   > Added to TODO:
   > 
   > 	* Allow inherited tables to inherit index
   
   Thank you, it's not a big problem that this doesn't happen, but it'd
   be nice to see it as an option when creating a table via inheritance.
   
   What about RULEs?  I wouldn't really have a use for that but others
   might.
   
   -- 
   -Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
   "I have the heart of a child; I keep it in a jar on my desk."
   
   

6. Re: INHERITS doesn't offer enough functionality

   Chris Bitmead <chris@bitmead.com> — 2000-10-17T10:21:44Z

   Alfred Perlstein wrote:
   
   > Thank you, it's not a big problem that this doesn't happen, but it'd
   > be nice to see it as an option when creating a table via inheritance.
   > 
   > What about RULEs?  I wouldn't really have a use for that but others
   > might.
   
   Actually it's a reasonably big deal. Apart from the obvious performance
   penalty for a deep inheritance hierarchy it affects the implementation
   of unique keys, referential integrity for inheritance and the
   transparancy of extending an inheritance hierarchy.