Re: Including PL/PgSQL by default - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Including PL/PgSQL by default
Date
Msg-id 47BEF3A1.2010502@dunslane.net
Whole thread Raw
In response to Re: Including PL/PgSQL by default  ("Roberts, Jon" <Jon.Roberts@asurion.com>)
Responses Re: Including PL/PgSQL by default
Re: Including PL/PgSQL by default
Re: Including PL/PgSQL by default
List pgsql-hackers

Roberts, Jon wrote:
> However, you can not create anything in Oracle without being given
> permission to create it.  The notion that you can create a function
> because you have connect rights to the database is foreign to me.
> Connect should mean connect, not connect AND create.
>
> Include the language by default and remove CREATE on the public schema.
>
>
>   

You'd need more than that.

For example, since we don't support temp functions, we should probably 
ban the creation of functions in temp schemas (which I found was possible).

cheers

andrew


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Linking backend in one piece
Next
From: Alvaro Herrera
Date:
Subject: Re: Linking backend in one piece