who can use plpgsql?
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
IIRC, if a superuser install pl/pgsql into
the template1 database, all subsequently created
databases get pl/pgsql already enabled.
Stephan Szabo
sszabo@bigpanda.com
On Wed, 18 Oct 2000, Jinsoo Hwang wrote:
Show quoted text
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