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
On Wed, May 6, 2009 at 12:48 PM, Marco Maccaferri wrote:
> 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
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
