On 06/05/2009 21:39 Merlin Moncure ha scritto:
probably, you had a transaction sitting around that is not closed (to see: select * from pg_stat_activity). the alter table is waiting for that transaction to finish, but itself blocks all _new_ transactions (alter table acquires a strong lock on the table). Cancel the alter table query or the query that is blocking your alter table. Again, check pg_stat_activity and ungranted locks (select * from pg_locks where granted = false).
By querying these tables I found that the connection pooling was not setup properly and that there were few unclosed sessions hanging around. Thank you for your help.
Regards, Marco. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
