2008/3/14, Pavan Deolasee <[EMAIL PROTECTED]>: > On Fri, Mar 14, 2008 at 5:19 AM, Clodoaldo > > <[EMAIL PROTECTED]> 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
