Re: [GENERAL] function permissions question

2007-12-08 Thread Greg Steffensen
Excellent, thanks for the quick response. Greg On Dec 9, 2007 1:18 AM, Tom Lane <[EMAIL PROTECTED]> wrote: > "Greg Steffensen" <[EMAIL PROTECTED]> writes: > > Hey, I'm slightly confused about how the permission checking is done > > when executing fu

[GENERAL] function permissions question

2007-12-08 Thread Greg Steffensen
Hey, I'm slightly confused about how the permission checking is done when executing functions. Basically, users that I've never granted execution permissions to are able to execute functions. Basically, why does this script (which I've tested on a fresh db, executing via psql as a superuser) succ

[GENERAL] plpythonu and bytea

2005-07-02 Thread Greg Steffensen
Hey, I'm trying to write some plpython procedures that read binary data from images on the disk and store it in bytea fields.  I'm basically trying to write a plpython procedure that accepts a varchar and returns a bytea, with these procedure contents: data = ""> return data (The actual procedure