problems selecting from altered table - Mailing list pgsql-general

From Rikard Pavelic
Subject problems selecting from altered table
Date
Msg-id 4677DF77.9060303@zg.htnet.hr
Whole thread Raw
Responses Re: problems selecting from altered table
Re: problems selecting from altered table
List pgsql-general
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

pgsql-general by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: Subquery problems
Next
From: "Sibte Abbas"
Date:
Subject: Re: Dynamic Log tigger (plpgsql)