On Thursday 19 February 2004 19:26, Josh Berkus wrote:
> Rodrigo,
>
> > I insist in my question, is there a way to compile the plpgsql codes or
>
> something like that, or its better to think about writting this postgres
> functions in C??
>
> No, there is not. Nor is there likely to be for
Rod,
> This is another one of those items where it would be nice if users
> didn't need access to read the system tables, but instead could rely on
> the information schema (with extensions) to see what they own or have
> access to use -- but nothing else.
Hmmm, that is a good question: can I, as
> 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?
This is another one of those items wher
Rodrigo Sakai wrote:
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?
Let me explain myself a
Rodrigo,
> I insist in my question, is there a way to compile the plpgsql codes or
something like that, or its better to think about writting this postgres
functions in C??
No, there is not. Nor is there likely to be for any PL, as it would add
significant overhead for no real gain.
Y
Rodrigo Sakai wrote:
I insist in my question, is there a way to compile the
plpgsql codes or something like that
no
think about writting this postgres functions in C??
yes
Joe
---(end of broadcast)---
TIP 9: the planner will ignore your desire
>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?
Let me explain myself a little better. Ac
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 c
So use Grant more wisely.
- Original Message -
From: "Rodrigo Sakai" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 19, 2004 2:44 PM
Subject: [SQL] Compiling pl/pgsql functions
>Hi, I'm responsable for the database here in the com
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.
Is there a way to do th
Through preliminary examination, it appears stored procedures using pl/pgsql
in PostgreSQL 7.3 are interpreted, rather than compiled?
When we insert a stored function into PostgreSQL, the syntax check is not done
until execution, and only on the branch/path of execution, not on the entire
funct
11 matches
Mail list logo
