From: | Jan Wieck <JanWieck(at)Yahoo(dot)com> |
---|---|
To: | Marcus Börger <marcus(dot)boerger(at)post(dot)rwth-aachen(dot)de> |
Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, ivan <iv(at)psycho(dot)pl>, Joe Conway <mail(at)joeconway(dot)com>, Dave Page <dpage(at)vale-housing(dot)co(dot)uk>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: php with postgres |
Date: | 2003-07-22 11:28:18 |
Message-ID: | 3F1D1FD2.3020507@Yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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(at)Yahoo(dot)com #
From | Date | Subject | |
---|---|---|---|
Next Message | Karel Zak | 2003-07-22 13:02:53 | CVS: compilation failed |
Previous Message | Andrew Dunstan | 2003-07-22 11:16:22 | a couple of suggestions |