On Fri, 04 Apr 2008 21:22:17 +0100 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? Uhm, every day you learn something new. Thanks for updating me, guys. Kind regards -- Andreas 'ads' Scherbaum German PostgreSQL User Group European PostgreSQL User Group - Board of Directors
