On Wed, 4 Aug 2004, PostgreSQL Bugs List wrote: > User-defined function is called inside transaction block (begin end) in php > script. There is loop in php script where this PL/pgsql functon is invoked > several times. On first iteration it cause no mistake, on second it cause > mistake like this: > > ERROR: relation with OID 165645734 does not exist > CONTEXT: PL/pgSQL function "session_recount_time_sec" line 35 at select > into variables > ERROR: current transaction is aborted, commands ignored until end of > transaction block
This is likely to mean that you're using temporary objects (or creating/dropping an object) inside the function and not doing so, through execute which is a known issue with plpgsql's queryplan saving. Without seeing the function definition, it's hard to say more. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
