<div dir="ltr">With postgresql version 9.6.3 ?<div><br></div><div>Is database dump that creates trouble ok for you?</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Jun 12, 2017 at 11:38 AM, Tatsuo Ishii <span dir="ltr"><<a href="mailto:ishii@sraoss.co.jp" target="_blank">ishii@sraoss.co.jp</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="HOEnZb"><div class="h5">> Hello,<br>
><br>
> I'm using pgpool for load balancing and failover, now version 3.6.4<br>
><br>
> I'm experiencing problem after upgrade of postgresql from 9.3 to 9.6.<br>
> I have some not ordinary table names in my database. And that worked well<br>
> for many years and now it would be really hard to change everything.<br>
><br>
> Problem is when I make simple select request:<br>
> postgres=# SELECT * FROM "class_<br>
> <a href="http://www.w3.org/1999/02/22-rdf-syntax-ns#Property" rel="noreferrer" target="_blank">http://www.w3.org/1999/02/22-<wbr>rdf-syntax-ns#Property</a>";<br>
><br>
> I got error, and pgpool close connection unexpectedly.<br>
><br>
> postgres=# SELECT * FROM "class_<br>
> <a href="http://www.w3.org/1999/02/22-rdf-syntax-ns#Property" rel="noreferrer" target="_blank">http://www.w3.org/1999/02/22-<wbr>rdf-syntax-ns#Property</a>";<br>
> FATAL: Backend throw an error message<br>
> DETAIL: Exiting current session because of an error from backend<br>
> HINT: BACKEND Error: "cross-database references are not implemented:<br>
> "class_<a href="http://www.w3.org/1999/02/22-rdf-syntax-ns#property" rel="noreferrer" target="_blank">http://www.w3.org/1999/<wbr>02/22-rdf-syntax-ns#property</a>""<br>
> server closed the connection unexpectedly<br>
> This probably means the server terminated abnormally<br>
> before or while processing the request.<br>
> The connection to the server was lost. Attempting reset: Succeeded.<br>
> postgres=#<br>
><br>
><br>
> When I execute same query directly on postgresql (not throught pgpool), it<br>
> works normally.<br>
><br>
> Thansk a lot<br>
> --<br>
> Armin<br>
<br>
</div></div>Please provide a self contained test case. I was not able to reproduce<br>
your problem here.<br>
<br>
test=# SELECT * FROM "class_<br>
<a href="http://www.w3.org/1999/02/22-rdf-syntax-ns#Property" rel="noreferrer" target="_blank">http://www.w3.org/1999/02/22-<wbr>rdf-syntax-ns#Property</a>";<br>
test"# ERROR: relation "class_<br>
<a href="http://www.w3.org/1999/02/22-rdf-syntax-ns#Property" rel="noreferrer" target="_blank">http://www.w3.org/1999/02/22-<wbr>rdf-syntax-ns#Property</a>" does not exist<br>
LINE 1: SELECT * FROM "class_<br>
^<br>
test=# CREATE TABLE "class_<br>
<a href="http://www.w3.org/1999/02/22-rdf-syntax-ns#Property" rel="noreferrer" target="_blank">http://www.w3.org/1999/02/22-<wbr>rdf-syntax-ns#Property</a>" (i int);<br>
test"# CREATE TABLE<br>
test=# SELECT * FROM "class_<br>
<a href="http://www.w3.org/1999/02/22-rdf-syntax-ns#Property" rel="noreferrer" target="_blank">http://www.w3.org/1999/02/22-<wbr>rdf-syntax-ns#Property</a>";<br>
test"# i<br>
---<br>
(0 rows)<br>
<br>
test=# \dt<br>
List of relations<br>
Schema | Name | Type | Owner<br>
--------+---------------------<wbr>------------------------------<wbr>--+-------+---------<br>
public | class_ +| table | t-ishii<br>
| <a href="http://www.w3.org/1999/02/22-rdf-syntax-ns#Property" rel="noreferrer" target="_blank">http://www.w3.org/1999/02/22-<wbr>rdf-syntax-ns#Property</a> | |<br>
public | pgbench_accounts | table | t-ishii<br>
public | pgbench_branches | table | t-ishii<br>
public | pgbench_history | table | t-ishii<br>
public | pgbench_tellers | table | t-ishii<br>
public | test_tbl | table | t-ishii<br>
(6 rows)<br>
<br>
Best regards,<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" rel="noreferrer" target="_blank">http://www.sraoss.co.jp/index_<wbr>en.php</a><br>
Japanese:<a href="http://www.sraoss.co.jp" rel="noreferrer" target="_blank">http://www.sraoss.co.<wbr>jp</a><br>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature" data-smartmail="gmail_signature">Armin</div>
</div>