Skip site navigation (1) Skip section navigation (2)

Updateable cursors patch

From: "FAST PostgreSQL" <fastpgs(at)fast(dot)fujitsu(dot)com(dot)au>
To: pgsql-patches(at)postgresql(dot)org
Subject: Updateable cursors patch
Date: 2007-04-04 18:36:52
Message-ID: 21558.10861175333802.fast.fujitsu.com.au@MHS (view raw or flat)
Thread:
Lists: pgsql-patches
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: updateablecursor.patch
Description: text/x-diff (42.2 KB)

Responses

pgsql-patches by date

Next:From: Markus SchiltknechtDate: 2007-04-04 18:55:26
Subject: Re: Auto Partitioning
Previous:From: FAST PostgreSQLDate: 2007-04-04 18:24:54
Subject: Re: COPY-able sql log outputs

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group