Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group