Hello I am not sure, but your solution will faill on scrollable cursors (it's similar to holdable cursors). I miss part about limits in documentation. Propably updatable cursors aren't supported by plpgsql (and it's point to ToDo).
Regards Pavel Stehule 2007/5/17, FAST PostgreSQL <[EMAIL PROTECTED]>:
Attached is an updated version of the updateable cursors patch against the latest cvs head. Most of the changes in the patch are to make it sync with the changes in CVS recently, for DECLARE CURSOR and EXPLAIN, as mentioned by Jaime in his mail below. Rgds, Arul Shaji FAST PostgreSQL wrote: > Right. I will send an updated patch against the CVS head in the next > couple of days. > > Jaime Casanova wrote: >> On 4/4/07, FAST PostgreSQL <[EMAIL PROTECTED]> wrote: >>> Attached is a working updateable cursors patch. The core >>> functionality has >>> been implemented and the patch also contains the regression tests and >>> documentation. >>> >> >> this one doesn't apply cleanly to HEAD because of the changes in >> http://archives.postgresql.org/pgsql-committers/2007-04/msg00447.php >> > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend > > ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq