Nathan McEachen wrote:
> connection1 performes query: "SELECT * FROM my_table";
> connection 2 performs DDL: "ALTER TABLE my_table ADD COLUMN my_col
> connection 2 seems to hang unless connection1 is closed (i.e.
> conneciton1.close() ).
Most likely, connection 1 has autocommit off and you have forgotten to
commit or rollback the transaction that your SELECT opened.
In response to
pgsql-jdbc by date
|Next:||From: Nathan McEachen||Date: 2006-01-24 03:36:25|
|Subject: Re: DDL hanging when different connection is left open|
|Previous:||From: Nathan McEachen||Date: 2006-01-24 02:48:03|
|Subject: DDL hanging when different connection is left open|