temporary tables, plpgsql and yes i bet this has been asked before

Поиск
Список
Период
Сортировка
От Murray Prior Hobbs
Тема temporary tables, plpgsql and yes i bet this has been asked before
Дата
Msg-id 3C5E6329.3000805@efone.com
обсуждение исходный текст
Ответы Re: temporary tables, plpgsql and yes i bet this has been asked  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: temporary tables, plpgsql and yes i bet this has been asked before  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
in a plpgsql function
   create temporary table X
   ....

   drop table X


then in another function
   loop
       call the other function
   end loop  

i get the problem that the second time the table is created (ie in the 
second call) it is not visible

now yes i could declare the table in the calling funtion but then the 
original function is less useful to me

any clues?

murray




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

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: casting question
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: temporary tables, plpgsql and yes i bet this has been asked