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