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

_______________________________________________
Pgpool-general mailing list
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general

Reply via email to