I'm working over Pavel's FOR-over-cursor patch:
http://archives.postgresql.org/pgsql-patches/2007-12/msg00001.php
(Although I previously complained that this was a bit pointless,
the argument that it's important for porting Oracle code won me over.)
I noticed that because the patch uses the same prefetch logic that
regular plpgsql FOR loops do, the "current row" as seen by the cursor
itself is typically not in sync with the current row of the loop.
This would mean in particular that UPDATE/DELETE WHERE CURRENT OF would
affect the "wrong" row of the table. This is fixable by not
prefetching, but at a performance cost. I wonder whether anyone knows
if Oracle users expect this combination to work at all?
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
