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

[Tatsuo Ishii]

> 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

Please provide a self contained test case. I was not able to reproduce
your problem here.

test=# SELECT * FROM "class_
http://www.w3.org/1999/02/22-rdf-syntax-ns#Property";
test"# ERROR:  relation "class_
http://www.w3.org/1999/02/22-rdf-syntax-ns#Property" does not exist
LINE 1: SELECT * FROM "class_
                      ^
test=# CREATE TABLE "class_
http://www.w3.org/1999/02/22-rdf-syntax-ns#Property" (i int);
test"# CREATE TABLE
test=# SELECT * FROM "class_
http://www.w3.org/1999/02/22-rdf-syntax-ns#Property";
test"#  i 
---
(0 rows)

test=# \dt
                               List of relations
 Schema |                        Name                         | Type  |  Owner  
--------+-----------------------------------------------------+-------+---------
 public | class_                                             +| table | t-ishii
        | http://www.w3.org/1999/02/22-rdf-syntax-ns#Property |       | 
 public | pgbench_accounts                                    | table | t-ishii
 public | pgbench_branches                                    | table | t-ishii
 public | pgbench_history                                     | table | t-ishii
 public | pgbench_tellers                                     | table | t-ishii
 public | test_tbl                                            | table | t-ishii
(6 rows)

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp