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

[Asaf Ohaion]

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)


-- 
Asaf Ohaion
Lingnu Open Source Consulting Ltd
09-7655871 (204), 0547-920828
http://www.lingnu.com