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

Re: relation 12345 is still open

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Johannes Bruegmann <johannes(at)jottbee(dot)org>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: relation 12345 is still open
Date: 2007-02-09 16:42:38
Message-ID: 1252.1171039358@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
Johannes Bruegmann <johannes(at)jottbee(dot)org> writes:
>>> What does it mean "relation 50435 is still open"?
>> 
>> What this probably means is that there is an active query somewhere
>> within your session that is referencing that table --- such as an
>> unclosed cursor or unfinished plpgsql FOR-in-SELECT loop.  

> Thank you very much for your prompt answer.

>> I don't see any such thing in the functions you showed us, but look
>> around in the rest of your application.

> I couldn't see anything either, but it has to be in the code i
> showed. Because if I implement it the way like [1], everything is
> working fine. 

Hmm.  Well, it could be a bug --- something hanging onto a relation
reference that it shouldn't have.  What PG version are you using
exactly?  Can you put together a self-contained test case, that is
a SQL script someone else could run to duplicate the error?

			regards, tom lane

In response to

Responses

pgsql-novice by date

Next:From: James LongDate: 2007-02-09 19:18:03
Subject: Re: Transaction vs. Savepoints
Previous:From: Tom LaneDate: 2007-02-09 16:21:59
Subject: Re: Transaction vs. Savepoints

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