On Tue, Jan 25, 2005 at 02:40:51AM -0500, Tom Lane wrote: > Neil Conway <[EMAIL PROTECTED]> writes: > > Someone at Fujitsu pointed out the following bug in 8.0: > > begin; > > savepoint x; > > create table abc (a int); > > insert into abc values (5); > > declare foo cursor for select * from abc; > > rollback to x; > > fetch from foo; -- hits an Assert() > > Offhand I'd say this should draw a "no such cursor as foo" error. > I'm too tired to look into why foo still exists after the rollback...
At this point, gdb says that the portal is in PORTAL_READY state. The code says to keep it open and reassign it to the parent subxact. I don't remember what the rationale for this was ... I'll review the discussion about this. -- Alvaro Herrera (<[EMAIL PROTECTED]>) "La rebeldía es la virtud original del hombre" (Arthur Schopenhauer) ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
