Scroll Cursor Bug?

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: Raw Message | Whole Thread | 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

Responses

Browse pgadmin-support by date

  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