Re: PG/DBI: 'NOTICE: UserAbortTransactionBlock and not in in-progress state'

Поиск
Список
Период
Сортировка
От Ed Loehr
Тема Re: PG/DBI: 'NOTICE: UserAbortTransactionBlock and not in in-progress state'
Дата
Msg-id 392E7F4C.AA455FAA@austin.rr.com
обсуждение исходный текст
Ответ на PG/DBI: 'NOTICE: UserAbortTransactionBlock and not in in-progress state'  (Markus Wagner <mawagner@mail.uni-mainz.de>)
Список pgsql-sql
Markus Wagner wrote:
> 
> Hi,
> 
> I am using PG 6.5.1 and DBI. My Perl programs always print to stderr:
> 
> "NOTICE: UserAbortTransactionBlock and not in in-progress state" or
> "NOTICE: EndTransactionBlock and not inprogress/abort state"
> 
> I tried to do <stmthandle> -> finish and <dbhandle> -> commit after each
> query, but the messages still appear.
> 
> Any hints?

I think that happens if the backend aborted (elogged) with an ERROR
message and you did not start a new transaction.  ERROR kills the current
transaction altogether in 6.5.*, IIRC.

Regards,
Ed Loehr


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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: aliases break my query
Следующее
От: "Mitch Vincent"
Дата:
Сообщение: date() indexing error..