Re: [HACKERS] Index corruption

Hiroshi Inoue wrote:

> > -----Original Message-----
> > From: owner-pgsql-hackers@postgreSQL.org
> > [mailto:owner-pgsql-hackers@postgreSQL.org]On Behalf Of Jan Wieck
>
> >     Thus,  IMHO  there  should  be  another  command added to the
> >     bootstrap parser.  This would recreate ALL  existing  indices
> >     (system  and user ones), but tell the visibility code somehow
> >     to ignore deleted tuples. I don't have the time to do it now,
> >     so at least I'd like to have a TODO item for it.
> >
>
> I may be able to implement reindex command unless you have
> the time to do it.
>
> Different from your suggestion,I would implement it in a non-bootstrap
> standalone postgres with the new option by which PostgreSQL ignores
> system indexes.
    Sounds good to me.



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) #