Re: Reindex does not finish 8.2.6

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.

Thanks,
Pavan


--
Pavan Deolasee
EnterpriseDB http://www.enterprisedb.com