Re: plpgsql: function throws error on second call! - Mailing list pgsql-general

From Bruce Momjian
Subject Re: plpgsql: function throws error on second call!
Date
Msg-id 200207300318.g6U3IGU24504@candle.pha.pa.us
Whole thread Raw
In response to Re: plpgsql: function throws error on second call!  (Janning Vygen <vygen@gmx.de>)
List pgsql-general
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@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-general by date:

Previous
From: Sanjeev Rathore
Date:
Subject: insert bytea type into PostgreSQL database
Next
From: "Jim Morcombe"
Date:
Subject: Are these error messages normal?