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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | James Long | 2007-02-09 19:18:03 | Re: Transaction vs. Savepoints |
Previous Message | Tom Lane | 2007-02-09 16:21:59 | Re: Transaction vs. Savepoints |