> I am working on support scrollable cursors in plpgpsm. Scrollable cursors
> are in ToDo for plpgsql too. I need new function
> SPI_cursor_fetch_with_direction(Portal portal, int direction, long count)
> where is possible set direction of fetch statement.

Sounds good.

Please ensure the default for PL/pgSQL remains as non-scrollable. That
may or may not be the same for plpgpsm.


Default plpgpsm cursors are non scrollable too. But I have to do two patches. Syntax of declare section is total different. Between SQL/PSM and plpgsql is only one big difference (in default values). SQL/PSM procedures are flagged SECURITY DEFINER and plpgsql run wit default SECURITY CALLER.

Pavel

_________________________________________________________________
Chcete sdilet sve obrazky a hudbu s prateli? http://messenger.msn.cz/


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq

Reply via email to