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

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: BUG #1546: Temp table isn't deleted at the end of a
Дата
Msg-id 20050318064510.D65163@megazone.bigpanda.com
обсуждение исходный текст
Ответ на BUG #1546: Temp table isn't deleted at the end of a transaction / ON COMMIT DROP has no effect  ("Oliver Siegmar" <o.siegmar@vitrado.de>)
Список pgsql-bugs
Дерево обсуждения 
On Fri, 18 Mar 2005, Oliver Siegmar wrote:

> On Friday 18 March 2005 14:29, Stephan Szabo wrote:
> > 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.
>
> I already tried to execute the 'CREATE TEMP TABLE' statement using EXECUTE to
> avoid cache problems - same problem!

You have to EXECUTE the insert as well.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: BUG #1546: Temp table isn't deleted at the end of a
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Possible temp table bug in PostgreSQL 7.4.7 / 8.0.1