<div dir="ltr">Hello,<div><br></div><div>I was using old version of pgpool (3.4.x) instead of new one.</div><div>With new one it works just normal.</div><div><br></div><div>Thanks a lot, and sorry for false alarm.</div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Jun 12, 2017 at 2:12 PM, 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"><span class="">> With postgresql version 9.6.3 ?<br>
<br>
</span>10.0 beta1.<br>
<span class=""><br>
> Is database dump that creates trouble ok for you?<br>
<br>
</span>Probably I don't need data. i.e. schema only dump is enough.<br>
Also I need pgpool.conf.<br>
<span class="im HOEnZb"><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>
<br>
</span><div class="HOEnZb"><div class="h5">> On Mon, Jun 12, 2017 at 11:38 AM, Tatsuo Ishii <<a href="mailto:ishii@sraoss.co.jp">ishii@sraoss.co.jp</a>> wrote:<br>
><br>
>> > 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),<br>
>> it<br>
>> > works normally.<br>
>> ><br>
>> > Thansk a lot<br>
>> > --<br>
>> > Armin<br>
>><br>
>> 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 |<br>
>> Owner<br>
>> --------+---------------------<wbr>------------------------------<br>
>> --+-------+---------<br>
>> public | class_ +| table |<br>
>> 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 |<br>
>> t-ishii<br>
>> public | pgbench_branches | table |<br>
>> t-ishii<br>
>> public | pgbench_history | table |<br>
>> t-ishii<br>
>> public | pgbench_tellers | table |<br>
>> t-ishii<br>
>> public | test_tbl | table |<br>
>> 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>
>><br>
><br>
><br>
><br>
> --<br>
> Armin<br>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature" data-smartmail="gmail_signature">Armin</div>
</div>