function that works only once...

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

Responses

Browse pgsql-novice by date

  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?