On 2005-05-01, Neil Conway <[EMAIL PROTECTED]> wrote: > Tzahi Fadida wrote: >> I think the solution can be either changing the FETCH_ALL to >> INT_MAX or changing the interface parameter count and subsequent usages >> to long. > > I think changing SPI_cursor_fetch() and SPI_cursor_move() to take a > "long" for the "count" parameter is the right fix for HEAD. It would > probably not be wise to backport, though, as it is probably not worth > breaking ABI compatibility for SPI during a stable release series.
While you're at it, how about a way to specify WITH SCROLL for a cursor created in SPI? At the moment, SPI_cursor_open hardwires the scroll option according to the result of ExecSupportsBackwardScan. -- Andrew, Supernews http://www.supernews.com - individual and corporate NNTP services ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
