Обсуждение: Re: BUG #1546: Temp table isn't deleted at the end of a

Поиск
Список
Период
Сортировка

Re: BUG #1546: Temp table isn't deleted at the end of a

От
Roy Badami
Дата:
> Given the error message, this seems to be the whole plpgsql caches
> query plans but we don't invalidate those plans when there are schema
> changes.  In all currently released versions you pretty much need to
> use EXECUTE on any queries where the table may go away, for example,
> any use of temp tables.

FWIW, this is documented behaviour (section 35.1 of the manual).

     -roy

Re: BUG #1546: Temp table isn't deleted at the end of a

От
Roy Badami
Дата:
>>>>> "Roy" == Roy Badami <roy@gnomon.org.uk> writes:

    Roy> FWIW, this is documented behaviour (section 35.1 of the
    Roy> manual).

That's 35.1 in the 8.0 doc, BTW.  It's 37.1 in the 7.4 doc.

    Roy>      -roy