Re: problems selecting from altered table

In response to Rikard Pavelic <rikard(dot)pavelic(at)zg(dot)htnet(dot)hr>:
>
> 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?

Have you tried altering the table, then disconnect and reconnect, then run
your stored procedure?

If that works, then the problem has to do with OID caching, which is known.

--
Bill Moran
http://www.potentialtech.com