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: (view raw or whole 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


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 


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-2015 The PostgreSQL Global Development Group