On Sat, 2007-06-09 at 16:25 -0400, Tom Lane wrote: > What I think we could do instead is not change any existing behavior of > cursor declarations, but when WHERE CURRENT OF is used, dig through the > execution node tree of the cursor to find the scan node for the target > table.
Sounds good. The cost is paid by the WHERE CURRENT OF query, not as an overhead on all cursors. Sounds like it will still be very fast too. Presumably still disallowing the WITH HOLD case. -- Simon Riggs EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly