From: | "Michal Szymanski" <biuro(at)globeinphotos(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #2494: SCROLL CURSOR does not worl |
Date: | 2006-06-23 13:44:24 |
Message-ID: | 200606231344.k5NDiONs013610@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 2494
Logged by: Michal Szymanski
Email address: biuro(at)globeinphotos(dot)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;
From | Date | Subject | |
---|---|---|---|
Next Message | Ermest | 2006-06-23 21:41:37 | BUG #2495: -i start up option blows pg_ctl program. |
Previous Message | Alexander Pravdin | 2006-06-23 08:08:17 | BUG #2493: bug with initdb under an administrator |