Markus Wagner wrote:
> 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.
In response to
pgsql-sql by date
|Next:||From: Mitch Vincent||Date: 2000-05-26 14:31:04|
|Subject: date() indexing error..|
|Previous:||From: Peter Eisentraut||Date: 2000-05-26 13:02:53|
|Subject: Re: aliases break my query |