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
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
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