Re: [HACKERS] 7.0 status request

--- Jan Wieck <wieck@debis.com> wrote:
> Bruce Momjian wrote:
> 
> > > > Here are the major open issues for 7.0 that I remember:
> > > >         Foreign Keys   - Jan
> > > >         WAL            - Vadim
> > > >         Function args  - Tom
> > > >         System indcxes - Bruce
> > > > Outer joins and new multi-query parse tree are questionable items
> for
> > > > 7.0.
> > >
> > > You might include "join syntax", which will be ready even if outer
> > > joins are not.
> > >
> > > Also, didn't some folks express concern that indices on system
> tables
> > > would make the backend more fragile? Did we resolve that issue?
> >
> > We have indexes on most system tables and it isn't a problem
> currently.
> 
>     It  is, because a corrupted index on a system table cannot be
>     corrected by drop/create, as a user defined index could be.
> 
>     I don't know why and when  reindexdb  disappeared,  but  that
>     script  was  a  last  resort  for  exactly the situation of a
>     corrupted  system  index.   Let  me  take  a  look  if   this
>     functionality could easily be recreated.
> 
> 
> Jan
> 
> --
> 
> #======================================================================#
> # It's easier to get forgiveness for being wrong than for being right. #
> # Let's break this rule - forgive me.                                  #
> #========================================= wieck@debis.com (Jan Wieck) #

For what its worth, TRUNCATE TABLE already rebuilds indexes on TRUNCATE'd
tables, so it shouldn't be that much of a leap, one would think.

Mike Mascari
(mascarim@yahoo.com)



__________________________________________________
Do You Yahoo!?
Bid and sell for free at http://auctions.yahoo.com