Re: proposal - new SPI cursor function
От | Pavel Stehule |
---|---|
Тема | Re: proposal - new SPI cursor function |
Дата | |
Msg-id | BAY20-F25C96ABC0023BBC63A2472F9B90@phx.gbl обсуждение исходный текст |
Ответ на | Re: proposal - new SPI cursor function ("Simon Riggs" <simon@2ndquadrant.com>) |
Список | pgsql-hackers |
> > > 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/
В списке pgsql-hackers по дате отправления: