[Pgpool-general] installing pgpool-recovery.sql : no schema has been selected to create in

[Tatsuo Ishii]

> pgpool-II 2.33
> 
> using (PostgreSQL) 8.3.8, on CentOS release 5.3 (Final)
> 
> after installing the c functions (make install under sql/pgpool-recovery
> running : psql -f pgpool-recovery.sql template1
> 
> yields :
> 
> psql:pgpool-recovery.sql:4: ERROR:  no schema has been selected to create in
> psql:pgpool-recovery.sql:10: ERROR:  no schema has been selected to create in
> 
> adding "public." in front of the "pgpool_recovery(text, text, text)"
> solves it :
> CREATE OR REPLACE FUNCTION public.pgpool_recovery(text, text, text)

If you remove public schema from the default search path *and* install
the function into the pubic schema, then that is your own problem, not
pgpool's. You should already have same issum with other functions.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp