Hi!
I noticed that some of the functions I created don't work anymore.
So I tired to reproduce the problem and this is what I came up with.
create table test(
id serial primary key,
tekst text);
insert into test values(1,'1'),(2,'2');
create function sel_test() returns test as
$$
declare red record;
begin
select * into red from test limit 1;
return red;
end
$$ language plpgsql;
select * from sel_test();
This all works ok, but if I do
alter table test drop column tekst;
then select * from sel_test(); doesn't work anymore
Even if I recreate the function.
Is this a known problem?
Regards,
Rikard