Raymond O'Donnell wrote:
> 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?
Yes, it should work on 8.3.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
