Re: DDL hanging when different connection is left open - Mailing list pgsql-jdbc

Nathan McEachen wrote:

> connection1 performes query: "SELECT * FROM my_table";
> connection 2 performs DDL: "ALTER TABLE my_table ADD COLUMN my_col
> INTEGER";
>
>
> 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.

-O