> 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 _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
