Re: Including PL/PgSQL by default

Tom Lane wrote:
> Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
>
>> Tom Lane wrote:
>>
>>> Anyway, as I said before, I don't object to installing plpgsql by
>>> default. What I do object to is installing it in a way that makes it
>>> difficult for the DBA to remove it, as would be the case if it were in
>>> template0 for example.
>>>
>
>
>> Perhaps it can be installed in template1 after the copy, if a certain
>> initdb option is passed?
>>
>
> Yeah, we'd have to rejigger initdb a bit. The bigger problem is that
> traditionally template0 has been seen as a backup for template1, and it
> wouldn't be (quite) that if the initial contents are different.
>
> Would it satisfy people if plpgsql were in postgres, but neither
> template DB, after initdb? This would make it available to the sort of
> person who's too lazy to learn about CREATE DATABASE, and one would
> think that if they can handle CREATE DATABASE then CREATE LANGUAGE
> is not beyond their powers.
>
>

I don't see any point in doing it at all unless it gets into new DBs by
default. So, no, I don't think that's going to be very helpful.

I don't see a huge problem in loading it to template1 after we copy
template1 to template0 - anyone who is going to touch template0 at any
time is likely to have enough postgres-fu to be able to manage.

cheers

andrew