Re: [HACKERS] Plan cache and name space behavior in 9.2

2012-09-14 Thread Hitoshi Harada
On Fri, Sep 14, 2012 at 12:55 PM, Tom Lane wrote: > Hitoshi Harada writes: >> I expected success in tname::regclass in the function chck(), but it >> actually fails for your first run in the session. > > Really? Not for me. > > In the example as given, I see success for "call 1" and then an erro

Re: [HACKERS] Plan cache and name space behavior in 9.2

2012-09-14 Thread Tom Lane
Hitoshi Harada writes: > I expected success in tname::regclass in the function chck(), but it > actually fails for your first run in the session. Really? Not for me. In the example as given, I see success for "call 1" and then an error at "call 2", which is occurring because we're trying to rep

[HACKERS] Plan cache and name space behavior in 9.2

2012-09-14 Thread Hitoshi Harada
I came across a new behavior in 9.2 with nested plpgsql functions and temporary table. create or replace function chck(tname text) returns void as $$ declare cnt int; begin select count(*) from pg_attribute where attrelid = tname::regclass::oid into cnt; end; $$ language plpgsql; create o