From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
---|---|
To: | Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: cannot drop active portal |
Date: | 2004-04-22 03:25:40 |
Message-ID: | 20040422032540.GA6947@dcc.uchile.cl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I wrote earlier:
> alvherre=# commit;
> ERROR: cannot drop active portal
>
> This happens while PortalDrop() tries to drop an active portal. In this
> state, I can't do anything else short of closing the connection. But
> this doesn't happen if I try to run a non-utility bogus statement
> ("SELECT foo"); the system then allows me to rollback the transaction.
Obviously I have to drop the unnamed portal in some kind of
AtSubAbort_Portals ... this means I will have to bite the bullet and get
a new transaction ID, which I was kind of postponing ... sorry for the noise.
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
Jajaja! Solo hablaba en serio!
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2004-04-22 03:57:49 | Re: contrib vs. gborg/pgfoundry for replication solutions |
Previous Message | Tom Lane | 2004-04-22 03:23:07 | Re: valgrind errors |