BUG #1204: user-defined function in transaction

From: "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1204: user-defined function in transaction
Date: 2004-08-04 12:31:41
Message-ID: 20040804123141.5B960CF4C88@www.postgresql.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1204
Logged by: Golkin Stanislav

Email address: stas(at)intercom(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Stephan Szabo 2004-08-04 14:19:01 Re: BUG #1204: user-defined function in transaction
Previous Message Bill Hernandez 2004-08-04 04:38:37 could not create shared memory segment - i386