Hi,
From: Gary Fu <[EMAIL PROTECTED]>
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
[EMAIL PROTECTED]
_______________________________________________
Pgpool-general mailing list
Pgpool-general@pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pgpool-general
