From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
---|---|
To: | Jinsoo Hwang <jshwang(at)anova(dot)inha(dot)ac(dot)kr> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: who can use plpgsql? |
Date: | 2000-10-18 01:34:16 |
Message-ID: | Pine.BSF.4.10.10010171833320.78787-100000@megazone23.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | The Hermit Hacker | 2000-10-18 01:41:23 | Re: Announce messages moderated? |
Previous Message | Michael Simcich | 2000-10-18 01:33:54 | RE: DOUBLE MESSAGE |