idle in transaction

Поиск
Список
Период
Сортировка
От Alexey Yudichev
Тема idle in transaction
Дата
Msg-id 8BCBF9DB739F034B87FE7C7D30EAE55C15A6CC@hqex2k.francoudi.com
обсуждение исходный текст
Ответы Multiple open ResultSets not allowed?
Re: idle in transaction
Список pgsql-jdbc
It seems that connection.commit() commits current transaction and immediately begins a new one so that connection
statusis always "idle in transaction". During that time no indicies could be created/dropped, no vaccum command can be
issuedetc because of locks I suppose.  
  I use PostgreSQL 7.1 and tried 7.2 drivers and 7.3 drivers (with option compatible=7.1).
  Is there anything that can be done to allow creating index without restarting the connection pool?

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Tim Farrell
Дата:
Сообщение: Re: embedding PostgreSQL in a Java application
Следующее
От: Jeff Kolesky
Дата:
Сообщение: Multiple open ResultSets not allowed?