And I couldn't find any solution to this on the list either.
I definitely want pl/pgsql in template1 so that any databases I create have access to pl/pgsql without having to explicitly install it in each new db I create in the cluster.
Recreating the database using psql dbname < dump.sql does work OK, but not pg_restore.
Can pg_restore be made to ignore the error?
John Sidney-Woollett
Martijn van Oosterhout wrote:
On Thu, Mar 10, 2005 at 01:31:26PM +0100, Janning Vygen wrote:
Hi,
i have a normal user with rights to create a db. template1 contains language plpgsql. the user wants to - dump his db - drop his db - create it again - and use the dump file to fill it.
it gives errors because of CREATE LANGUAGE statements inside the dump.
I don't beleive there is. But it's not really needed, you get and error and the restore continues. The only thing different is that you don't get a message, the result is the same.
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
