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@xxxxxx Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
