Re: plperl exception catching - Mailing list pgsql-general

From Bricklen Anderson
Subject Re: plperl exception catching
Date
Msg-id 458067E5.1020106@presinet.com
Whole thread Raw
In response to Re: plperl exception catching  (Marc Evans <Marc@SoftwareHackery.Com>)
Responses Re: plperl exception catching  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Marc Evans wrote:
> OK, I must be missing something obvious:
>
> c3i=> CREATE OR REPLACE FUNCTION foo_trigger() RETURNS TRIGGER AS $$
> c3i$>   eval { spi_exec_query('INSERT INTO FOO_BAR VALUES(1)'); } ||
> c3i$>   spi_exec_query('SELECT 1 as foo');
> c3i$> $$ LANGUAGE plperl;
> ERROR:  creation of Perl function failed: 'eval "string"' trapped by
> operation mask at line 2.
>

Try as plperlu

pgsql-general by date:

Previous
From: Marc Evans
Date:
Subject: Re: plperl exception catching
Next
From: Tony Caduto
Date:
Subject: Re: grant all privileges on database