Merlin>No one is arguing that that you should send it any every time (at least -- I hope not).
Well, what is your suggestion exactly? pgjdbc is NOT using "prepare ..." sql command. I'm inclined to suppose, it will not use "prepare..." even after your fix. Merlin>Again, not in pooling scenarios Merlin>The problems integrating server side Merlin>prepared statements with pgbouncer are well known. I'm afraid, they are not. Your words are "This feature should be immediately be incorporated by the JDBC driver" yet you have not raised that subject on pgsql-jdbc mailing list/github issue. That is not very fair. Let me just name an alternative, so you can see what "a step back" could be: What if pg-bouncer generated _fake_ ParameterStatus(backend_id=...) messages to pgjdbc? Then pgjdbc can learn true backend session id and it can use proper set of prepared statements. Basically, pgjdbc could have prepared statement cache per backend_id. Well, it is not a 100% solution, however it is yet another approach to "pgbouncer" problem, and it will support all the PostgreSQL versions. It fits into current frontend-backend protocol as all clients are supposed to handle ParameterStatus messages, etc. Vladimir -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
