Re: Temporary tables

On Fri, Jan 13, 2006 at 05:23:42PM -0000, Raymond O'Donnell wrote:
> The first time I call "select testfunc();", I get 0 as expected.
> However, subsequent calls return an error:
>
> ERROR: relation with OID 80845 does not exist
> CONTEXT: SQL statement "SELECT count(*) from TestTbl"
> PL/pgSQL function "testfunc" line 7 at select into variables
>
> Why should the temporary table be there the first time around and not
> after that, since it's created anew at the start of the function?

See 'Why do I get "relation with OID ##### does not exist" errors
when accessing temporary tables in PL/PgSQL functions?' in the FAQ:

http://www.postgresql.org/docs/faqs.FAQ.html#item4.19

See also numerous past discussions in the list archives.

--
Michael Fuhr