Re: Including PL/PgSQL by default

Robert Treat <xzilla@users.sourceforge.net> writes:
> On Thursday 21 February 2008 21:33, Tom Lane wrote:
>> So it's still 100% unclear to me who we are catering to.

> There are a lot of people who have a database provider of some sort who 
> creates a database for them, giving them ownership of that specific database, 
> with pg_hba.conf specifying connection only to that db. They are then free to 
> muck about that database, installing anything they want, but they cannot load 
> any procedural languages since they only have non-superuser accounts.  (This 
> does give them access to plsql, but not plpgsql).  Sadly a lot of these 
> arrangements preclude (for valid reasons or not) the installation of any 
> contrib modules or installation of any procedural languages.  It is these 
> users that 3rd party application developers (ie. mediawiki types) are trying 
> to accommodate. They would like to be able to take advantage of plpgsql in 
> their applications, but without it being included by default they have to 
> exclude it from their application. 

That argument *was* valid ... before 8.3.  Nowadays non-superuser DB
owners can install trusted PLs in their DBs by themselves.  (At least
by default.)  So I'm still unconvinced that we need more changes.
        regards, tom lane