Eric Worden wrote: > The recursive function creates a temp table [...] I > have version 8.1.10.
While I haven't looked in detail, I'd be surprised if this wasn't an issue with pre-8.3 versions lack of any way to automatically re-generate cached plans in functions. Try running your code on an 8.3 installation and see if you still get the issue. I strongly suspect you won't. If this does prove to be the case, there are workarounds for pre-8.3 versions, usually involving the use of EXECUTE to bypass the cache and force re-planning of statements at every execution. However, if it's practical to do so upgrading to 8.3 might be a nicer and (in the long run) easier option. -- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
