Re: Review: prepare plans of embedded sql on function start

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Andy Colson <andy(at)squeakycode(dot)net>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, pavel(dot)stehule(at)gmail(dot)com
Subject: Re: Review: prepare plans of embedded sql on function start
Date: 2011-09-05 22:04:33
Message-ID: 4E654771.5040309@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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 should require one, though,
especially since we now load plpgsql by default. It might be better just
to call it plpgsql_prepare_on_start.)

cheers

andrew

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2011-09-05 22:10:41 Re: pg_upgrade automatic testing
Previous Message Tom Lane 2011-09-05 21:26:00 Re: [GENERAL] pg_upgrade problem