X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 95A0CD1DF71
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 19 Feb 2004 13:59:16 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 59876-07
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 19 Feb 2004 09:59:19 -0400 (AST)
Received: from mail1.dr.myx.net (mail1.dr.myx.net [217.10.193.161])
	by svr1.postgresql.org (Postfix) with ESMTP id 4A3F6D1DF05
	for <pgsql-sql@postgresql.org>; Thu, 19 Feb 2004 09:58:54 -0400 (AST)
Received: from appserver (unknown [82.137.2.202])
	by mail1.dr.myx.net (mydomain.myx.net) with ESMTP
	id 7871F3009F4; Thu, 19 Feb 2004 15:58:48 +0200 (EET)
Message-ID: <010901c3f6f0$eb313380$6500a8c0@wylog.local>
From: "Viorel Dragomir" <bc@vio.ro>
To: "Rodrigo Sakai" <rodrigo@2bfree.com.br>,
	<pgsql-sql@postgresql.org>
References: <20040219134412.27393.qmail@hm10.locaweb.com.br>
Subject: Re: Compiling pl/pgsql functions
Date: Thu, 19 Feb 2004 16:01:48 +0200
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200402/273
X-Sequence-Number: 16963

So use Grant more wisely.

----- Original Message ----- 
From: "Rodrigo Sakai" <rodrigo@2bfree.com.br>
To: <pgsql-sql@postgresql.org>
Sent: Thursday, February 19, 2004 2:44 PM
Subject: [SQL] Compiling pl/pgsql functions


>    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 that, or the only way is writting my functions in
C??????
>
>   Thanks for any help and regards to all!!!
>
>
>
> =====================
> Rodrigo Sakai
> Database Programmer
> rodrigo@2bfree.com.br
> http://www.2bfree.com.br
> Tel:  (55) (11) 5083-5577
> Fax: (55) (11) 5549-3598
> =====================
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match
>