Re: plpgsql: function throws error on second call!

From: Janning Vygen <vygen(at)gmx(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: plpgsql: function throws error on second call!
Date: 2002-07-26 18:09:50
Message-ID: 200207261809.g6QI9pM03696@janning.planwerk6.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Elielson Fontanezi 2002-07-26 18:34:12 1 milion data insertion
Previous Message Patrick Nelson 2002-07-26 18:02:02 Re: Import csv