[Pgpool-general] pgadmin and pgpool-II problem

[Yoshiyuki Asaba]

Hi,

From: Gary Fu <gfu at saicmodis.com>
Subject: [Pgpool-general] pgadmin and pgpool-II problem
Date: Tue, 03 Jun 2008 15:20:31 -0400

> 2008-06-03 14:32:14 LOG:   pid 14002: statement: SELECT nspname, 
> session_user=nspname AS isuser FROM pg_namespace
> ;
> 2008-06-03 14:32:14 ERROR: pid 14002: pool_process_query: 1 th kind C 
> does not match with master connection kind D
> 2008-06-03 14:32:14 LOG:   pid 14002: do_child: exits with status 1 due 
> to error
> 
> ---------------- select sql from backend host 0
> 
> [nppdist.gfu].nppsd3> select * from pg_namespace;
>       nspname       | nspowner |               nspacl               
> --------------------+----------+-------------------------------------
>  pg_toast           |       10 |
>  pg_temp_1          |       10 |
>  pg_catalog         |       10 | {postgres=UC/postgres,=U/postgres}
>  information_schema |       10 | {postgres=UC/postgres,=U/postgres}
>  public             |       10 | {postgres=UC/postgres,=UC/postgres}
>  pg_temp_4          |       10 |

pg_temp_* are temporary schema name for temp table if I'm correct.
Does anybody know when pg_temp_* is dropped?

--
Yoshiyuki Asaba
y-asaba at sraoss.co.jp