Re: plpgsql: function throws error on second call!

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: plpgsql: function throws error on second call!
Дата
Msg-id 200207300318.g6U3IGU24504@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: plpgsql: function throws error on second call!  (Janning Vygen <vygen@gmx.de>)
Список 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 по дате отправления:

Предыдущее
От: Sanjeev Rathore
Дата:
Сообщение: insert bytea type into PostgreSQL database
Следующее
От: "Jim Morcombe"
Дата:
Сообщение: Are these error messages normal?