Re: cannot drop active portal - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: cannot drop active portal
Date
Msg-id 20040422032540.GA6947@dcc.uchile.cl
Whole thread Raw
In response to cannot drop active portal  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List 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!


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: contrib vs. gborg/pgfoundry for replication solutions
Next
From: Jan Wieck
Date:
Subject: Re: contrib vs. gborg/pgfoundry for replication solutions