| From: | Larry Morroni <lam170(at)yahoo(dot)com> |
|---|---|
| To: | pgadmin-support(at)postgresql(dot)org |
| Subject: | Scroll Cursor Bug? |
| Date: | 2005-06-20 19:48:35 |
| Message-ID: | WZ-dnYxyBtIMgCrfRVn-vA@comcast.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
Hi, I am hitting an issue when using SCROLL CURSORS.
My Setup:
- WinXP running PGAdminIII v1.2.2
- PostgreSQL 8 Server
My Test Function:
CREATE OR REPLACE FUNCTION DemoFunction () RETURNS varchar(50) AS
$$
DECLARE CursorProductGroups SCROLL CURSOR FOR SELECT * FROM TEST_TABLE;
RETURN NULL;
END;
$$
LANGUAGE plpgsql
;
The Error that the Query Tool spits out:
ERROR: syntax error at or near "CURSOR"
CONTEXT: invalid type name "SCROLL CURSOR FOR SELECT * FROM TEST_TABLE"
compile of PL/pgSQL function "demofunction" near line 1
It seems like the Query Tool has a bug with this because my demo looks
just like the examples given in the PostgreSQL documentation.
Any ideas?
Larry Morroni
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sim Zacks | 2005-06-21 07:29:03 | Re: Scroll Cursor Bug? |
| Previous Message | Vasilev Max | 2005-06-18 15:43:36 | Re: Compiling pgadminIII on SuSE 9.3 |