Jon Jensen wrote:
>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.
>
>
>
We could make it somewhat cleaner by having a flag on pg_dump that
allowed/suppressed the language creation for plpgsql.
cheers
andrew
