Marcus Börger wrote:
>
> Here's the current log while reusing the persistent connection:
>
> DEBUG: InitPostgres
> DEBUG: StartTransactionCommand
> DEBUG: query: select getdatabaseencoding()
> DEBUG: ProcessQuery
> DEBUG: CommitTransactionCommand
> DEBUG: StartTransactionCommand
> DEBUG: query: RESET ALL
> DEBUG: ProcessUtility: RESET ALL
> DEBUG: CommitTransactionCommand
> DEBUG: StartTransactionCommand
> DEBUG: query: BEGIN;ROLLBACK;
> DEBUG: ProcessUtility: BEGIN;ROLLBACK;
> DEBUG: CommitTransactionCommand
> DEBUG: StartTransactionCommand
> DEBUG: ProcessUtility: BEGIN;ROLLBACK;
> DEBUG: CommitTransactionCommand
> DEBUG: pq_recvbuf: unexpected EOF on client connection
>
And this is the wrong order of things. The BEGIN;ROLLBACK; has to be
done first, otherwise if the connection was left in an aborted open
transaction by the previous script, the other two actions will fail.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #