Re: [HACKERS] 7.0 status request

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(at)debis(dot)com (Jan Wieck) #