Re: Alter command getting stuck on a table - Mailing list pgsql-admin

On Tue, 2020-01-07 at 14:58 +0530, Shrikant Bhende wrote:
> I am trying to add a column to a table but it's not working, I have also tried
> reindex and drop on the same table but those commands are also getting stuck.

There is a concurrent session which has an open transaction which
holds some lock on the table in question.

Look for old "active" or "idle in transaction" sessions in "pg_stat_activity"
and see that they get closed.  Then the ALTER TABLE will work fine.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com