Re: Compiling pl/pgsql functions - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: Compiling pl/pgsql functions
Date
Msg-id 20040219081426.D53888@megazone.bigpanda.com
Whole thread Raw
In response to Compiling pl/pgsql functions  ("Rodrigo Sakai" <rodrigo@2bfree.com.br>)
Responses Re: Compiling pl/pgsql functions  (Rod Taylor <rbt@rbt.ca>)
List pgsql-sql
On Thu, 19 Feb 2004, Rodrigo Sakai wrote:

>    Hi, I'm responsable for the database here in the company, and I like
>    to know if is there a way to compile my pl/pgsql functions, its not a
>    performance problem, it is more a security problem, i don like to
>    have somebody looking into my codes and see the company rules.

AFAIK there's not much you can do for obfuscation of pl functions right
now since someone will be able to see the src text in pg_proc. However,
are you allowing people that you don't want to see the code access to
write arbitrary sql to the database?


pgsql-sql by date:

Previous
From: "Philippe Lang"
Date:
Subject: crosstabs
Next
From: "scott.marlowe"
Date:
Subject: Re: Distributed Transactions