Search Postgresql Archives

problems selecting from altered table

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux