problems selecting from altered table

Поиск
Список
Период
Сортировка
От Rikard Pavelic
Тема problems selecting from altered table
Дата
Msg-id 4677DF77.9060303@zg.htnet.hr
обсуждение исходный текст
Ответы Re: problems selecting from altered table  (Bill Moran <wmoran@potentialtech.com>)
Re: problems selecting from altered table  (Richard Huxton <dev@archonet.com>)
Список 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 по дате отправления:

Предыдущее
От: "Merlin Moncure"
Дата:
Сообщение: Re: Subquery problems
Следующее
От: "Sibte Abbas"
Дата:
Сообщение: Re: Dynamic Log tigger (plpgsql)