Re: Reindex does not finish 8.2.6

2008/3/14, Pavan Deolasee <pavan.deolasee@gmail.com>:
> On Fri, Mar 14, 2008 at 5:19 AM, Clodoaldo
>
> <clodoaldo.pinto.neto@gmail.com> wrote:
>
>  >
>
> >  >  Try vacuuming pg_class, pg_index, pg_attribute manually and see if that
>  >  >  makes the problem go away.
>  >
>  >  It does not go away.
>  >
>
>
> Can it be a case where some other open transaction is holding a lock
>  on the table ? Note that REINDEX would block even some other transaction
>  is inserting/deleting/updating the table.

Postgresql was restarted twice, but yes, it is as if the crash left
some kind of permanent lock somewhere.

Regards, Clodoaldo Pinto Neto