| From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
|---|---|
| To: | Andreas 'ads' Scherbaum <adsmail(at)wars-nicht(dot)de> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: creating a temp table in a function |
| Date: | 2008-04-04 20:22:17 |
| Message-ID: | 47F68DF9.8070202@iol.ie |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alex Adriaanse | 2008-04-04 20:24:39 | Re: Out of memory |
| Previous Message | Tom Lane | 2008-04-04 20:22:07 | Re: Question about pg_catalog.pg_trigger. |