Re: Plan invalidation design

On 2/19/07, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Gregory Stark <stark(at)enterprisedb(dot)com> writes:
> > If you prepare "select *" and add a column, you're saying the query should
> > start failing?
>
> Either fail or change output; which you like better? The whole point of
> this exercise is to support plpgsql functions that do something like
>
> create temp table foo ...
> select * into rec from foo ...
> drop table foo ...

If that's the case, do you think there is a simpler way to handle this
problem than plan invalidation? Maybe I'm oversimplifying things a
bit here, but how about something like:

create local table foo ...
select * into rec from foo ...

this isn't completely unsurprising...we have 'SET LOCAL, etc.

merlin