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 13EDDD1E151 for ; Thu, 19 Feb 2004 16:20:19 +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 19228-05 for ; Thu, 19 Feb 2004 12:20:14 -0400 (AST) Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210]) by svr1.postgresql.org (Postfix) with ESMTP id DC000D1D283 for ; Thu, 19 Feb 2004 12:20:13 -0400 (AST) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 80BEE35596; Thu, 19 Feb 2004 08:20:12 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 7D95D35590; Thu, 19 Feb 2004 08:20:12 -0800 (PST) Date: Thu, 19 Feb 2004 08:20:12 -0800 (PST) From: Stephan Szabo To: Rodrigo Sakai Cc: pgsql-sql@postgresql.org Subject: Re: Compiling pl/pgsql functions In-Reply-To: <20040219134412.27393.qmail@hm10.locaweb.com.br> Message-ID: <20040219081426.D53888@megazone.bigpanda.com> References: <20040219134412.27393.qmail@hm10.locaweb.com.br> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/275 X-Sequence-Number: 16965 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?