Cursor case-sensitivity

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
Thread:
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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Yichen Xie 2003-01-27 09:16:24 [CHECKER] 9 potential out-of-bounds array access errors
Previous Message Bradley Baetz 2003-01-27 07:29:19 Re: [BUGS] New hashed IN code ignores distinctiveness of subquery