From: | Niclas Hedell <niclas(at)headlong(dot)se> |
---|---|
To: | pgsql novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | function that works only once... |
Date: | 2003-07-31 15:20:27 |
Message-ID: | p05200f00bb4eddd96115@[192.168.0.37] |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi list,
I've a strange problem here that someone might know the answer to. I
have a function in plpgsql that works only the first time after
creating (installing) the function. After that I get the following
error:
Fatal - ERROR: pg_class_aclcheck: relation 51755 not found
I've tried to find pg_class_aclcheck in pg_class but it's not there.
Here is my function:
create or replace function display_attributes(varchar) returns varchar as '
declare
classNameVar alias for $1;
query_string text;
tablename varchar(20);
begin
query_string := ''create view the_groupview as select * from
getattribute('' || quote_literal(classNameVar) || '')'';
execute query_string;
select into tablename the_tablename from the_groupview;
drop view the_groupview;
return tablename;
end;'
language 'plpgsql' with (isstrict);
Thanx in advance! :-)
Cheers,
Nick
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-08-01 01:28:50 | Re: Unable to start postmaster |
Previous Message | Godshall Michael | 2003-07-31 14:32:10 | Re: pg_atoi error? |