Hi.
I have a weird problem with PostgreSQL on a Windows machine. This is a
test installation used to beta test a webapplication running with
Tomcat, so most of the times it sits idle. Yesterday and today I had to
update some table definitions, so issued the 'alter table...' command
and the se
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
t
