stefan <stefan@xxxxxxxx> writes: > However, due to the fact that in 9.0, the language is in template1 and > owned by postgres, a non superuser database owner will not have the > right to create or replace this language in any newly created database > owned by himself. True. > 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. Or just ignore the error during restore. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
