Re: GUC failure on exception - Mailing list pgsql-hackers

From Tim Bunce
Subject Re: GUC failure on exception
Date
Msg-id 20100217123527.GW373@timac.local
Whole thread Raw
In response to GUC failure on exception  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: GUC failure on exception
List pgsql-hackers
Did this ever get turned into a formal bug report with a number?

Tim.

On Thu, Jan 14, 2010 at 07:39:09PM -0500, Andrew Dunstan wrote:
> 
> Tim Bunce just showed me the following oddity:
> 
>    andrew=# SET SESSION plperl.use_strict = on;
>    SET
>    andrew=# SHOW plperl.use_strict;
>     plperl.use_strict
>    -------------------
>     on
>    (1 row)
> 
>    andrew=# DO $$ elog(ERROR,"error") $$ language plperl;
>    ERROR:  error at line 1.
>    CONTEXT:  PL/Perl anonymous code block
>    andrew=# SHOW plperl.use_strict;
>     plperl.use_strict
>    -------------------
>     off
>    (1 row)
> 
> 
> Somehow we have lost the setting, because the first use of plperl,
> which called the plperl init code, failed.
> 
> It appears that whatever rolls it back forgets to put the GUC
> setting back as it was, and now it's lost, which is pretty darn
> ugly. And you can now run code which fails the 'strict' tests.
> 
> If anyone has a quick idea about how to fix that would be nice.
> Otherwise I'll try to delve into it as time permits.
> 
> cheers
> 
> andrew
> 
> -- 
> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
> 


pgsql-hackers by date:

Previous
From: Tim Bunce
Date:
Subject: Re: PostgreSQL::PLPerl::Call - Simple interface for calling SQL functions from PostgreSQL PL/Perl
Next
From: Andrew Dunstan
Date:
Subject: Re: GUC failure on exception