Re: pl/pgsql enabled by default - Mailing list pgsql-hackers

From Neil Conway
Subject Re: pl/pgsql enabled by default
Date
Msg-id 427D7405.2090605@samurai.com
Whole thread Raw
In response to Re: pl/pgsql enabled by default  (Mike Mascari <mascarm@mascari.com>)
Responses Re: pl/pgsql enabled by default
List pgsql-hackers
Mike Mascari wrote:
> People who use views to achieve row security, which is a rather common 
> paradigm, cannot allow users to create functions with side effects.

Can you elaborate? I'm not sure I follow you.

(I'll note anyway that (1) SQL functions can have side effects: CREATE 
FUNCTION foo() RETURNS VOID AS 'DELETE FROM ...', for example (2) 
Administrators can always choose to drop pl/pgsql for a particular 
database, disable it at initdb time, or REVOKE usage of pl/pgsql for 
particular users.)

-Neil


pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: [GENERAL] Invalid unicode in COPY problem
Next
From: Mike Mascari
Date:
Subject: Re: pl/pgsql enabled by default