Re: call the same pl/pgsql procedure twice in the same connection

Bruce Momjian wrote:
>
> Jan, instead of doing cache invalidation to fix temporary tables, can we
> disable cached plans for functions that use temporary tables?
   I  was  thinking  of  a different approach. Enhancing the SPI   manager to detect if a plan uses  temporary  objects
and  to   remember  the  original  querystring  in the SPI_plan. Having   callbacks when temp object  beeing  destroyed
into  the  SPI   manager,  causing  it to reparse and plan on the next call to   SPI_execp() would do it for everything
thatuses SPI.
 


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #