Re: who can use plpgsql?

IIRC, if a superuser install pl/pgsql into
the template1 database, all subsequently created
databases get pl/pgsql already enabled.

Stephan Szabo
sszabo(at)bigpanda(dot)com

On Wed, 18 Oct 2000, Jinsoo Hwang wrote:

> Hi,
> I am running a small db-class using postgresql.
> While I was trying to use PL/pgSQL, I found out
> that I need to do createlang first.
> But in my default setup, only the user which
> has createuser privillege can use that command.
> So, as a postgres super user I did update
> the pg_shadow table to give students
> usesuper value to 't' which seems to me
> overprivilleged(?).
> Is there any way to control this problem?
> I did look into the manual but... :-(
> Thanks in advance.
>
> Jinsoo
>