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@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------