Re: plperl strict mode - Mailing list pgsql-patches

From Alvaro Herrera
Subject Re: plperl strict mode
Date
Msg-id 20050524144156.GC8743@surnet.cl
Whole thread Raw
In response to plperl strict mode  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: plperl strict mode  (Andrew Dunstan <andrew@dunslane.net>)
List 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.

pgsql-patches by date:

Previous
From: "Dave Page"
Date:
Subject: Re: [PATCH] pg_autovacuum commandline password hiding.
Next
From: Tom Lane
Date:
Subject: Re: [PATCH] pg_autovacuum commandline password hiding.