>> 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.