| From: | jonathansfl <jonathanbrinkman(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: temp tables not dropping at end of script |
| Date: | 2011-06-13 15:32:43 |
| Message-ID: | 1307979163586-4484759.post@n5.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
we're having a similar situation, where FunctionA calls FunctionB inside a
cursor. FunctionB DROPs Temp table, then creates temp table. FunctionA runs
through the cursor fine but breaks after the last loop, unable to DROP
temporary table "because it is being used by active queries in this
session."
Those sessions should have been closed after each loop!
Here is my ticket on this:
http://postgresql.1045698.n5.nabble.com/Can-t-drop-temp-table-in-subfunction-during-cursor-loop-being-used-by-active-queries-td4482806.html#a4484134
Here is another similar (and unanswered) ticket:
http://forums.enterprisedb.com/posts/list/849.page
--
View this message in context: http://postgresql.1045698.n5.nabble.com/temp-tables-not-dropping-at-end-of-script-tp4286391p4484759.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2011-06-13 15:32:47 | Re: Re: Can't drop temp table in subfunction during cursor loop (being used by active queries) |
| Previous Message | Craig Ringer | 2011-06-13 14:38:16 | Re: determine client os |