Lists: | pgsql-bugs |
---|
From: | "Key88 SF" <key88sf(at)hotmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Cursor case-sensitivity |
Date: | 2003-01-27 08:58:19 |
Message-ID: | F724uC0PcewUiz9xWyh0000006c@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
Not sure if this is known or not, but apparently cursors names are not
appropriately case-lowered when dealing with functions that return cursors.
Using the example straight from the documentation at
http://developer.postgresql.org/docs/postgres/plpgsql-cursors.html:
This works:
BEGIN;
SELECT reffunc('funccursor');
FETCH ALL IN funccursor;
COMMIT;
But this doesn't work:
BEGIN;
SELECT reffunc('funcCursor');
FETCH ALL IN funcCursor;
COMMIT;
This 2nd one gives a warning in the log of:
WARNING: PerformPortalFetch: portal "funccursor" not found.
-Dave
_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE*
http://join.msn.com/?page=features/virus
From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Key88 SF" <key88sf(at)hotmail(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: Cursor case-sensitivity |
Date: | 2003-01-27 14:19:12 |
Message-ID: | 25485.1043677152@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
"Key88 SF" <key88sf(at)hotmail(dot)com> writes:
> BEGIN;
> SELECT reffunc('funcCursor');
> FETCH ALL IN funcCursor;
> COMMIT;
> WARNING: PerformPortalFetch: portal "funccursor" not found.
I don't think this is a bug. You should have written
FETCH ALL IN "funcCursor";
regards, tom lane