errors during Connection_clear/Connection_close
Martin Pala
martinp at tildeslash.com
Fri Mar 28 00:27:49 CET 2008
Thanks for report ... should be fixed ;)
Martin
Paul J Stevens wrote:
> Hi there, me again :-)
>
> Whenever I close a connection that holds a prepared statement, the postgres
> backend logs an error like this:
>
> 2008-03-20 09:49:54 CET LOG: execute 1804289383: select user_idnr from
> dbmail_users where userid=$1
> 2008-03-20 09:49:54 CET DETAIL: parameters: $1 = 'testuser1'
> 2008-03-20 09:49:54 CET ERROR: syntax error at or near "1804289383" at character 12
> 2008-03-20 09:49:54 CET STATEMENT: DEALLOCATE 1804289383;
>
> it's *always* at character 12, where of course the stmt ID varies. It only
> occurs when I close the connection, I assume because that triggers a
> Connection_clear, which releases the statements.
>
> This doesn't appear to affect functionality, but it doesn't exactly inspire
> confidence either, I suppose.
>
> Any ideas?
>
More information about the libzdb-general
mailing list