Re: cannot drop active portal

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!

In response to

Browse pgsql-hackers by date

  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