errors during Connection_clear/Connection_close

Paul J Stevens paul at nfg.nl
Thu Mar 20 10:42:39 CET 2008


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?

-- 
  ________________________________________________________________
  Paul Stevens                                      paul at nfg.nl
  NET FACILITIES GROUP                     GPG/PGP: 1024D/11F8CD31
  The Netherlands________________________________http://www.nfg.nl


More information about the libzdb-general mailing list