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 F0F0F5E46C1 for ; Wed, 1 Sep 2004 19:35:34 -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 33391-02 for ; Wed, 1 Sep 2004 22:35:32 +0000 (GMT) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id E56A85E46F9 for ; Wed, 1 Sep 2004 19:35:30 -0300 (ADT) Received: from [192.168.1.20] (clbb-248.saw.net [64.146.135.248]) (authenticated) by hosting.commandprompt.com (8.11.6/8.11.6) with ESMTP id i81MZPh07177; Wed, 1 Sep 2004 15:35:25 -0700 Message-ID: <41364DF2.4050909@commandprompt.com> Date: Wed, 01 Sep 2004 15:32:18 -0700 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Brian Knox Cc: pgsql-interfaces@postgresql.org Subject: Re: pl/perl in postgresql 8.0 beta References: <4135FC65.2070505@comcast.net> In-Reply-To: <4135FC65.2070505@comcast.net> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/2 X-Sequence-Number: 5077 Brian Knox wrote: > I noticed the changelog for Postgresql mentions some interesting > things in relation to pl/perl: > > "New Perl Server-Side Language > A new version of the plperl server-side language now supports a > persistent shared storage area, triggers, returning records and > arrays of records, and SPI calls to access the database." > > Does anyone have some working examples of pl/perl using these new > capabilities? The documentation in the 8.0 beta for pl/perl has not > been updated and I'm looking for this information. There is scan documentation in the actual src/pl/plperl that gives some examples. You can also get the new version of plPerl for 7.4.3+ as well at: http://www.commandprompt.com/files/plperl-30072004.tar.gz Sincerely, Joshua D. Drake > > Also, is it still possible to use untrusted pl/perl in 8.0, and if so, > what are the steps for setting it up? > > Thank you, > Brian > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com PostgreSQL Replicator -- production quality replication for PostgreSQL