Can I get some comments on this? I know the work was completed pre-feature freeze, but submitted only recently.
--------------------------------------------------------------------------- Gavin Sherry wrote: > Attached is a patch implementing updatable cursors in HEAD. Regression > test and documentation are included. > > Updateable cursors are used as follows: > > begin; > declare foo cursor for select * from bar for update; > fetch foo; > update bar set abc='def' where current of foo; > fetch foo; > delete from bar where current of foo; > commit; > > > Two points: > > i) The patch doesn't implement updateable cursors for cursors marked WITH > HOLD. I have working code for this and will send it in soon. > > ii) I've implemented a new snapshot type since, AFAICT, updateable cursors > have a type of tuple visibility. Namely, if the base table of a cursor is > updated based on that cursor, the new and old tuples are removed from the > cursor's set of visible tuples. Like wise, deleted tuples are also > removed. > > Thanks, > > Gavin Content-Description: [ Attachment, skipping... ] > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org