<div dir="ltr">Hello,<div><br></div><div>I'm using pgpool for load balancing and failover, now version 3.6.4<br></div><div><br></div><div>I'm experiencing problem after upgrade of postgresql from 9.3 to 9.6.</div><div>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.</div><div><br></div><div>Problem is when I make simple select request:</div><div><font face="monospace, monospace">postgres=# SELECT * FROM "class_<a href="http://www.w3.org/1999/02/22-rdf-syntax-ns#Property">http://www.w3.org/1999/02/22-rdf-syntax-ns#Property</a>";</font><br></div><div><br></div><div>I got error, and pgpool close connection unexpectedly. </div><div><br></div><div><div><font face="monospace, monospace">postgres=# SELECT * FROM "class_<a href="http://www.w3.org/1999/02/22-rdf-syntax-ns#Property">http://www.w3.org/1999/02/22-rdf-syntax-ns#Property</a>";</font></div><div><font face="monospace, monospace">FATAL: Backend throw an error message</font></div><div><font face="monospace, monospace">DETAIL: Exiting current session because of an error from backend</font></div><div><font face="monospace, monospace">HINT: BACKEND Error: "cross-database references are not implemented: "class_<a href="http://www.w3.org/1999/02/22-rdf-syntax-ns#property">http://www.w3.org/1999/02/22-rdf-syntax-ns#property</a>""</font></div><div><font face="monospace, monospace">server closed the connection unexpectedly</font></div><div><font face="monospace, monospace"> This probably means the server terminated abnormally</font></div><div><font face="monospace, monospace"> before or while processing the request.</font></div><div><font face="monospace, monospace">The connection to the server was lost. Attempting reset: Succeeded.</font></div><div><font face="monospace, monospace">postgres=#</font></div><div><br></div><div><br></div><div>When I execute same query directly on postgresql (not throught pgpool), it works normally.</div><div><br></div><div>Thansk a lot</div>-- <br><div class="gmail-m_-832992990560992894gmail_signature">Armin</div>
</div></div>