From: | Larry Morroni <lam170(at)yahoo(dot)com> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: Scroll Cursor Bug? |
Date: | 2005-06-21 12:53:25 |
Message-ID: | wPSdnfbRZepekCXfRVn-sg@comcast.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Thanks for the response, Sim.
- I forgot to include the BEGIN in the example I sent. Even with the
BEGIN, I get the same error.
- I tried this with psql and you are right, the server spits back the
message. Therefore, I will move this to the postgres forum.
Thanks!
Sim Zacks wrote:
> 1) You don't have a Begin. The format is Declare then Begin and then
> lastly End
>
> 2) My understanding is that these error messages would come directly from the
> server and not the query tool. Have you tried running the same query
> using psql?
>
> Sim Zacks
>
> ________________________________________________________________________________
>
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
From | Date | Subject | |
---|---|---|---|
Next Message | Daniel Seichter | 2005-06-21 13:58:02 | Add 'CHECK( length(fieldname) > 0 )' to a field |
Previous Message | Sim Zacks | 2005-06-21 07:29:03 | Re: Scroll Cursor Bug? |