> > is it planed cursor out of a transaction in 7.4 ? > > I do not think we will allow cross-transaction cursors ever. > What would > it mean to have a cross-transaction cursor, anyway? Does it show a > frozen snapshot as of the time it was opened? The usefulness of that > seems awfully low in comparison to the pain of implementing it.
It is usually used with comitted read isolation for an outer select on one table and one transaction per row where the action usually involving additional tables depends on the selected row. This is to keep transactions small and avoid locking out other activity. The outer cursor is declared "WITH HOLD". I think it is a useful feature. Of course a workaround is to open two connections. Andreas ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
