I have a database where I remove the schema public. When I try to use the createlang script, it fails like this ...
createdb fooCREATE DATABASE
psql foo -c "select version()"
version --------------------------------------------------------------------- PostgreSQL 7.4.1 on i386-portbld-freebsd4.9, compiled by GCC 2.95.4 (1 row)
DROP DATABASEcreatelang plpgsql foo dropdb foo
createdb fooCREATE DATABASE
psql foo -c "drop schema public"DROP SCHEMA
createlang plpgsql foocreatelang: language installation failed: ERROR: no schema has been selected to create in
I read through the man page, but I do not see how to specify the schema to createlang ...
I can add the language using the manual syntax, I am just wondering if there is a simple way to use the script.
_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings