Re: Updatable cursors thoughts

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