Therefore the only solution I see is to drop plpgsql from template1, or
writing a wrapper script that exploits the -l and -L options of pg_restore.
Yes. Though I could see an option to create a template database without plpgsql
in it for use by non-superuser users and leave template1 as is.
Adrian,
Thanks for suggesting that. I had not thought about that option and it
may just be the best.
Cheers,
Stefan.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general