Re: Usability, MySQL, Postgresql.org, gborg, contrib,

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