| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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 | Content-Type | Size |
|---|---|---|
| updateablecursor.patch | text/x-diff | 42.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Markus Schiltknecht | 2007-04-04 18:55:26 | Re: Auto Partitioning |
| Previous Message | FAST PostgreSQL | 2007-04-04 18:24:54 | Re: COPY-able sql log outputs |