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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general