Your patch has been added to the PostgreSQL unapplied patches list at:
http://momjian.postgresql.org/cgi-bin/pgpatches
It will be applied as soon as one of the PostgreSQL committers reviews
and approves it.
---------------------------------------------------------------------------
FAST PostgreSQL wrote:
> Attached is a working updateable cursors patch. The core functionality has
> been implemented and the patch also contains the regression tests and
> documentation.
>
> However there are still a couple of TODOs that needs to be done. The planner
> has to be taught to treat a DELETE/UPDATE WHERE CURRENT OF as a TidScan.
> Currently it follows the sequential scan route and extracts the current tuple
> based on the cursor position from the portal. Also, an issue that needs to
> be looked at is how to treat joins with an updateable cursor. Currently it is
> allowed and when it comes to delete or update, an error message is thrown
> from the executor.
>
> Rgds,
> Arul Shaji
>
>
[ Attachment, skipping... ]
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
