Re: php with postgres

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 #