problems selecting from altered table

From: Rikard Pavelic <rikard(dot)pavelic(at)zg(dot)htnet(dot)hr>
To: pgsql-general(at)postgresql(dot)org
Subject: problems selecting from altered table
Date: 2007-06-19 13:51:51
Message-ID: 4677DF77.9060303@zg.htnet.hr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sibte Abbas 2007-06-19 14:10:23 Re: Dynamic Log tigger (plpgsql)
Previous Message Chris Browne 2007-06-19 13:49:45 Re: [pgsql-advocacy] [PERFORM] Postgres VS Oracle