Jon Jensen wrote:
On Wed, 28 Apr 2004, Christopher Kings-Lynne wrote:
It has to work with older dumps that will try to recreate pl/pgsql themselves explicitly.Seriously - I'd like to raise my voice in favor of installing plpgsql
in template1 by default. I haven't heard any good reason not to (nor
even a bad reason).
This wouldn't be a problem, though, would it? The dumps don't run inside a transaction so after the failure to create PL/PgSQL because it already exists, the import would continue as before.
We could make it somewhat cleaner by having a flag on pg_dump that allowed/suppressed the language creation for plpgsql.
cheers
andrew
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
