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
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 |