[pgpool-general: 5571] Problem after upgrade of postgresql from 9.3 to 9.6

[Armin Nesiren]

Hello,

I'm using pgpool for load balancing and failover, now version 3.6.4

I'm experiencing problem after upgrade of postgresql from 9.3 to 9.6.
I have some not ordinary table names in my database. And that worked well
for many years and now it would be really hard to change everything.

Problem is when I make simple select request:
postgres=# SELECT * FROM "class_
http://www.w3.org/1999/02/22-rdf-syntax-ns#Property";

I got error, and pgpool close connection unexpectedly.

postgres=# SELECT * FROM "class_
http://www.w3.org/1999/02/22-rdf-syntax-ns#Property";
FATAL:  Backend throw an error message
DETAIL:  Exiting current session because of an error from backend
HINT:  BACKEND Error: "cross-database references are not implemented:
"class_http://www.w3.org/1999/02/22-rdf-syntax-ns#property""
server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.
postgres=#


When I execute same query directly on postgresql (not throught pgpool), it
works normally.

Thansk a lot
-- 
Armin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20170612/9f6daf4e/attachment.htm>