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

[Armin Nesiren]

With postgresql version 9.6.3 ?

Is database dump that creates trouble ok for you?

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20170612/01da0b28/attachment-0001.html>