Skip site navigation (1) Skip section navigation (2)

Re: plperl strict mode

From: Alvaro Herrera <alvherre(at)surnet(dot)cl>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: "Patches (PostgreSQL)" <pgsql-patches(at)postgresql(dot)org>
Subject: Re: plperl strict mode
Date: 2005-05-24 14:41:56
Message-ID: 20050524144156.GC8743@surnet.cl (view raw or flat)
Thread:
Lists: pgsql-patches
On Sat, May 21, 2005 at 04:04:36PM -0400, Andrew Dunstan wrote:

Andrew,

> it works like this:
> 
> andrew=# create or replace function foo() returns text language plperl 
> as $$ $x = 1; return 'hello'; $$;
> CREATE FUNCTION
> andrew=# select foo();
> ERROR:  creation of Perl function failed: Global symbol "$x" requires 
> explicit package name at (eval 11) line 1.

Hmm, is there a way to have a validator function and have the strict
check at function creation too?  I know these things are reported with
perl -c, not sure if they can be reached with the C interface.


-- 
Alvaro Herrera (<alvherre[a]surnet.cl>)
Dios hizo a Adán, pero fue Eva quien lo hizo hombre.

In response to

Responses

pgsql-patches by date

Next:From: Tom LaneDate: 2005-05-24 15:02:16
Subject: Re: [PATCH] pg_autovacuum commandline password hiding.
Previous:From: Dave PageDate: 2005-05-24 14:36:45
Subject: Re: [PATCH] pg_autovacuum commandline password hiding.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group