Re: pg_index updates and SI invalidation

Your patch has been added to the PostgreSQL unapplied patches list at:

http://momjian.postgresql.org/cgi-bin/pgpatches

It will be applied as soon as one of the PostgreSQL committers reviews
and approves it.

---------------------------------------------------------------------------

Pavan Deolasee wrote:
> On 4/3/07, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> >
> >
> > Where are we on this?
> >
> >
> > ---------------------------------------------------------------------------
> >
> > Tom Lane wrote:
> > >
> > > [squint...] How can that fail during a reload if it worked the first
> > > time? Needs a closer look at what's happening.
> > >
> >
>
> Please see the attached updated patch, based on Tom's comments.
>
> Attempt to reload index information for system indexes such as
> pg_class_oid_index can cause infinite recursion. But I realized that
> we don't need to reload system index information because we
> neither allow CREATE INDEX or CIC on system relations. Only
> REINDEX is allowed which does not need any reload. So we skip
> index information reload for system relations.
>
> Thanks,
> Pavan
>
> --
>
> EnterpriseDB http://www.enterprisedb.com

[ Attachment, skipping... ]

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +