Re: [BUGS] BUG #8046: PL/pgSQL plan caching regression

2013-04-08 Thread Dmitriy Igrishin
2013/4/9 Tom Lane > dmit...@gmail.com writes: > > CREATE OR REPLACE FUNCTION rec(type_name_ regclass, id_ bigint) > > RETURNS record > > LANGUAGE plpgsql > > STABLE > > AS $function$ > > DECLARE > > r_ record; > > BEGIN > > EXECUTE 'SELECT * FROM '||type_name_::text||' WHERE id = $1' > >

Re: [BUGS] BUG #8046: PL/pgSQL plan caching regression

2013-04-08 Thread Tom Lane
dmit...@gmail.com writes: > CREATE OR REPLACE FUNCTION rec(type_name_ regclass, id_ bigint) > RETURNS record > LANGUAGE plpgsql > STABLE > AS $function$ > DECLARE > r_ record; > BEGIN > EXECUTE 'SELECT * FROM '||type_name_::text||' WHERE id = $1' > INTO r_ USING id_; > RAISE NOTICE '%