Re: GUC failure on exception

Поиск
Список
Период
Сортировка
От Tim Bunce
Тема Re: GUC failure on exception
Дата
Msg-id 20100217123527.GW373@timac.local
обсуждение исходный текст
Ответ на GUC failure on exception  (Andrew Dunstan <andrew@dunslane.net>)
Ответы Re: GUC failure on exception  (Andrew Dunstan <andrew@dunslane.net>)
Список 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 по дате отправления:

Предыдущее
От: Tim Bunce
Дата:
Сообщение: Re: PostgreSQL::PLPerl::Call - Simple interface for calling SQL functions from PostgreSQL PL/Perl
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: GUC failure on exception