> -----Original Message-----
> From: Andrew Dunstan [mailto:andrew@dunslane.net] 
> Sent: Tuesday, April 27, 2004 12:55 PM
> To: pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] Usability, MySQL, Postgresql.org, 
> gborg, contrib,
> 
> 
> Jim C. Nasby wrote:
> 
> > 
> >I would still argue that if any language should be installed 
> by default 
> >it should be plpgsql and not java. As I mentioned, everyone using a 
> >database already knows SQL; not nearly as many know java.
> >  
> >
> 
> I know both. :-).
> 
> 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).

I offered the same opinion a while back, and was told that plpgsql is a
security hole.

Tue, 27 Apr 2004 13:32:44 -0700
"Dann Corbit" <DCorbit@connx.com>
Re: Usability, MySQL, Postgresql.org, gborg, contrib,
On Tue, Apr 27, 2004 at 01:32:44PM -0700, Dann Corbit wrote:

> > From: Andrew Dunstan [mailto:andrew@dunslane.net] 

> > 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).
> 
> I offered the same opinion a while back, and was told that plpgsql is a
> security hole.

Huh?  Maybe we should fix it instead, because it's trusted.

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Coge la flor que hoy nace alegre, ufana. ï¿½Quiï¿½n sabe si nacera otra maï¿½ana?"

Tue, 27 Apr 2004 19:12:57 -0400
Alvaro Herrera <alvherre@dcc.uchile.cl>
Re: Usability, MySQL, Postgresql.org, gborg, contrib,
>>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.

> I offered the same opinion a while back, and was told that plpgsql is a
> security hole.

The we can make it not have USAGE privileges to public by default??

Chris


Wed, 28 Apr 2004 09:28:26 +0800
Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: Usability, MySQL, Postgresql.org, gborg, contrib,
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

Wed, 28 Apr 2004 12:45:06 +0000 (UTC)
Jon Jensen <jon@endpoint.com>
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

Wed, 28 Apr 2004 10:02:33 -0400
Andrew Dunstan <andrew@dunslane.net>
Re: Usability, MySQL, Postgresql.org, gborg, contrib,