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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
