Re: Review: prepare plans of embedded sql on function start - Mailing list pgsql-hackers

From Andy Colson
Subject Re: Review: prepare plans of embedded sql on function start
Date
Msg-id 4E654CC0.7060906@squeakycode.net
Whole thread Raw
In response to Re: Review: prepare plans of embedded sql on function start  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: Review: prepare plans of embedded sql on function start
List pgsql-hackers
On 09/05/2011 05:04 PM, Andrew Dunstan wrote:
>
>
> On 09/05/2011 05:03 PM, Andy Colson wrote:
>> Pavel, this patch:
>>
>> https://commitfest.postgresql.org/action/patch_view?id=624
>>
>> It applied clean and compiled ok, but I cannot get it to work at all.
>>
>> $ psql
>> Timing is on.
>> psql (9.2devel)
>> Type "help" for help.
>>
>> andy=# set plpgsql.prepare_plans to on_start;
>> ERROR: unrecognized configuration parameter "plpgsql.prepare_plans"
>>
>>
>
> Did you add plpgsql to custom_variable_classes? It looks like you might not have. (I'm not sure why plpgsql switch
shouldrequire one, though, especially since we now load plpgsql by default. It might be better just to call it
plpgsql_prepare_on_start.)
>
> cheers
>
> andrew
>
>

Ah, yep, that was the problem, thank you.

-Andy


pgsql-hackers by date:

Previous
From: Alexander Korotkov
Date:
Subject: Re: WIP: Fast GiST index build
Next
From: Alvaro Herrera
Date:
Subject: Re: Large C files