On Wed, 28 Apr 2004, Christopher Kings-Lynne wrote: > >>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). > > It has to work with older dumps that will try to recreate pl/pgsql > themselves explicitly.
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. Jon ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html