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-08 19:10:46
Message-ID: 8226.1170961846@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
Johannes Bruegmann <johannes(at)jottbee(dot)org> writes:
> Function _clean [6] wraps function _drop_part [4], and tries to drop
> some parts not needed any longer. Dropping a part using _drop_part [4]
> works. However, dropping some parts with function _clean [6] fails
> with the following error message: 
> NOTICE:  relation 50435 is still open
> 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.  I don't
see any such thing in the functions you showed us, but look around
in the rest of your application.

			regards, tom lane

In response to

Responses

pgsql-novice by date

Next:From: AndreasDate: 2007-02-09 05:04:59
Subject: Transaction vs. Savepoints
Previous:From: Johannes BruegmannDate: 2007-02-08 15:53:49
Subject: relation 12345 is still open

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