| From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
|---|---|
| To: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Executing a user created function twice give an error |
| Date: | 2008-12-02 13:05:12 |
| Message-ID: | 49353288.6000503@iol.ie |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 02/12/2008 12:50, A. Kretschmer wrote:
> PG cached the plan and the also the OID for affected tables. To avoid
> this, use EXECUTE 'insert your query here' for create or delete tables
> within plpgsql.
This has been fixed in 8.3 - you no longer have to construct dynamically
any statements which touch temporary tables. If you have to do a lot of
this, it would be worth your while upgrading....not to mention the
performance improvements also.
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 | Teodor Sigaev | 2008-12-02 13:05:39 | Re: [TextSearch] syntax error while parsing affix file |
| Previous Message | A. Kretschmer | 2008-12-02 12:50:44 | Re: Executing a user created function twice give an error |