Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

One possible re-phrasing would be: “Why do temporary tables in PL/PgSQL functions give me “missing oid” errors?

April 26, 2017errors functions MISSING OID pgsql PL possible re-phrasing tables Temporary

0

Posted

One possible re-phrasing would be: “Why do temporary tables in PL/PgSQL functions give me “missing oid” errors?

1 Answer

0

Posted

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.