Postgres Pro
Downloads
Home   >   mailing lists

Re: Problem running "ALTER TABLE...", ALTER TABLE waiting - Mailing list pgsql-general

From Tom Lane
Subject Re: Problem running "ALTER TABLE...", ALTER TABLE waiting
Date
Msg-id 27601.1344473932@sss.pgh.pa.us
Whole thread Raw
In response to Re: Problem running "ALTER TABLE...", ALTER TABLE waiting  (Brian McNally <bmcnally@uw.edu>)
Responses Re: Problem running "ALTER TABLE...", ALTER TABLE waiting
List pgsql-general
Tree view 
Brian McNally <bmcnally@uw.edu> writes:
> Ok, I'm running with all available updates and kernel 2.6.18-308.4.1.el5
> but am still having the same problem.

It's fairly clearly blocked on a lock ... have you looked into the
pg_locks view to see what is holding the lock?

(I'm wondering about a prepared transaction, myself.  There isn't much
else that could hold a lock across a server restart.)

            regards, tom lane

pgsql-general by date:

Previous
From: Brian McNally
Date:
Subject: Re: Problem running "ALTER TABLE...", ALTER TABLE waiting
Next
From: Geert Mak
Date:
Subject: Re: processing large amount of rows with plpgsql