Re: BUG #1204: user-defined function in transaction

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.