X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 77D3053A7B for ; Thu, 21 Apr 2005 17:38:42 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 94806-05 for ; Thu, 21 Apr 2005 20:38:12 +0000 (GMT) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id B25CE53B2E for ; Thu, 21 Apr 2005 17:38:00 -0300 (ADT) Received: from [192.168.1.52] (fc1smp [66.93.38.87]) (authenticated bits=0) by hosting.commandprompt.com (8.12.8/8.12.8) with ESMTP id j3LKWYma003010; Thu, 21 Apr 2005 13:32:34 -0700 Message-ID: <42680F29.4030907@commandprompt.com> Date: Thu, 21 Apr 2005 13:38:01 -0700 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Mozilla Thunderbird 1.0.2-1.3.2 (X11/20050324) X-Accept-Language: en-us, en MIME-Version: 1.0 To: KeithW@narrowpathinc.com Cc: PostgreSQL Interfaces Subject: Re: plperl user function References: <20050421194438.M68704@narrowpathinc.com> <42680480.7080805@commandprompt.com> <20050421200109.M30783@narrowpathinc.com> In-Reply-To: <20050421200109.M30783@narrowpathinc.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.024 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/69 X-Sequence-Number: 5485 > > Another question: Is there an issue with using the untrusted perl language? IIRC you have to be a postgresql superuser (postgres) to execute an untrusted language function. > If the code is tested and working is there any real reason to continue to have > "use strict;" and "use warnings;" in the function? Only for manageability in the future. Sincerely, Joshua D. Drake > > Kind Regards, > Keith > > ---------------------------(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 -- Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240 PostgreSQL Replication, Consulting, Custom Programming, 24x7 support Managed Services, Shared and Dedication Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/