Re: plpgsql: function throws error on second call!

EXECUTE is mentioned in the FAQ on the web site.

---------------------------------------------------------------------------

Janning Vygen wrote:
> Am Freitag, 26. Juli 2002 19:42 schrieb Stephan Szabo:
> > If you're going to create/drop a table in a function,
> > you'll want to use execute any time you're working with the
> > table, otherwise it'll cache the plan from the original table
> > that you've dropped.
>
> Thanks a lot!! i ve posted it to the interactive docs (of
> course mentioning your name), because i love the interactive docs
> with php but the postgresql docs are less used
>
> so there is one thing i can do for postgresql: putting all my newbie
> experience into the idoc :-)
>
> kind regards,
> janning
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026