Re: creating a temp table in a function

On 04/04/2008 20:47, Andreas 'ads' Scherbaum wrote:

>> I have a function that creates a temp table and drops it on commit.  If
>> I run the function twice in the same psql interactive session, I get an
>> error.  If I run it twice in two different psql sessions (using the -c
>> flag), I get no error.  Is this expected behavior?  If so, why?
>
> Create a query in a text string and run the query with EXECUTE.

Wasn't this fixed in 8.3? - Is it not the case that you no longer have
to handle temp tables in plpgsql functions via EXECUTE?

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------