One possible re-phrasing would be: “Why do temporary tables in PL/PgSQL functions give me “missing oid” errors?
I think this matches the existing answer much better. Given further consideration, my previous suggestions regarding using exception handing to manage temporary table construction, etc. would be more appropriate in the proper documentation than in a FAQ. I will say that for most cases of usage of temporary tables for storage from within pg/pgsql functions, using dynamic sql is probably not the optimial solution unless dynamic sql is more generally preferred.
Related Questions
- Why do I get "relation with OID ##### > does not exist" errors when accessing temporary tables in PL/PgSQL > functions?
- One possible re-phrasing would be: "Why do temporary tables in PL/PgSQL functions give me "missing oid" errors?
- Why do I get "relation with OID ##### does not exist" errors when accessing temporary tables in PL/PgSQL functions?