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 4E66B335.5020306@squeakycode.net
Whole thread Raw
In response to Review: prepare plans of embedded sql on function start  (Andy Colson <andy@squeakycode.net>)
List pgsql-hackers
Hi Pavel,

I can get:

ERROR:  permission denied to set parameter "plpgsql.prepare_plans"

with this script:


set plpgsql.prepare_plans to on_start;

create or replace function test1(a integer) returns integer as $$
begin
return a+1;
end;
$$ language plpgsql;


If test1() exists, then this script works fine:

select * from test1(1);

set plpgsql.prepare_plans to on_start;

create or replace function test1(a integer) returns integer as $$
begin
return a+1;
end;
$$ language plpgsql;


-Andy


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pgpass comment suggestion
Next
From: Peter Geoghegan
Date:
Subject: Re: Large C files