BUG #2494: SCROLL CURSOR does not worl

Поиск
Список
Период
Сортировка
От Michal Szymanski
Тема BUG #2494: SCROLL CURSOR does not worl
Дата
Msg-id 200606231344.k5NDiONs013610@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #2494: SCROLL CURSOR does not worl  ("Jim C. Nasby" <jnasby@pervasive.com>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      2494
Logged by:          Michal Szymanski
Email address:      biuro@globeinphotos.com
PostgreSQL version: 8.1
Operating system:   Windows
Description:        SCROLL CURSOR does not worl
Details:

Function with scroll cursor  cannot be compiled.
ERROR:  syntax error at or near "CURSOR"
CONTEXT:  invalid type name "SCROLL CURSOR FOR SELECT * FROM freeconet.alias
WHERE mask >"
compile of PL/pgSQL function "dummy" near line 3

Function that I want compile.
CREATE OR REPLACE FUNCTION freeconet.dummy (
                                 )    RETURNS INT8 AS $$
DECLARE
rowvar freeconet.ALIAS%ROWTYPE;
DECLARE curs1  SCROLL CURSOR  FOR SELECT * FROM freeconet.alias WHERE
mask>='+4850X' LIMIT 100 ;
BEGIN
    BEGIN

OPEN curs1;
FETCH curs1 INTO rowvar;

    EXCEPTION
    WHEN OTHERS THEN
         RAISE WARNING '.... Kod bledu = %', SQLSTATE;
             RETURN -1;   /* blad danych */
    END;
     RAISE WARNING ' mask=%',rowvar.mask;
     RETURN 1;
END;
$$ LANGUAGE 'plpgsql' VOLATILE;

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "Ermest"
Дата:
Сообщение: BUG #2495: -i start up option blows pg_ctl program.
Следующее
От: ""
Дата:
Сообщение: BUG #2492: "unexpected EOF on client connection" message in log