Re: [HACKERS] cannot drop active portal

2004-04-22 Thread Alvaro Herrera
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

[HACKERS] cannot drop active portal

2004-04-21 Thread Alvaro Herrera
Hackers, While playing with code to enable subtransactions in the storage manager, I run across this strangeness: alvherre=# begin; begin;-- start a subtransaction BEGIN BEGIN alvherre=# drop table foo; -- no such table ERROR: no existe la tabla foo

Re: [HACKERS] cannot drop active portal

2004-04-21 Thread Tom Lane
Alvaro Herrera [EMAIL PROTECTED] writes: Why is a portal kept active after a utility statement fails? I think you've broken AtAbort_Portals ... regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and unsubscribe