BUG #1204: user-defined function in transaction

The following bug has been logged online:

Bug reference:      1204
Logged by:          Golkin Stanislav

Email address:      stas@intercom.ru

PostgreSQL version: 7.4

Operating system:   FREBSD 4.3

Description:        user-defined function in transaction

Details:

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


And it doesn't depend on input data. On first loop it's always OK and then
it's always error