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

[Tatsuo Ishii]

> With postgresql version 9.6.3 ?

10.0 beta1.

> Is database dump that creates trouble ok for you?

Probably I don't need data. i.e. schema only dump is enough.
Also I need pgpool.conf.

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

> On Mon, Jun 12, 2017 at 11:38 AM, Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
> 
>> > 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
>>
> 
> 
> 
> -- 
> Armin