| Lists: | pgsql-hackers |
|---|
| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | plpgsql error message |
| Date: | 2009-06-17 13:40:39 |
| Message-ID: | 200906171640.39276.peter_e@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
In plpgsql, if you write
OPEN var BLAH
you can an error message like this:
ERROR: syntax error ...
DETAIL: Expected "FOR", to open a reference cursor.
But what is a "reference cursor"? Isn't this rather saying "... to open a
cursor, a reference to which will be stored in your variable"? Anyone got a
better idea for a wording?
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: plpgsql error message |
| Date: | 2009-06-17 15:25:12 |
| Message-ID: | 27153.1245252312@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> In plpgsql, if you write
> OPEN var BLAH
> you can an error message like this:
> ERROR: syntax error ...
> DETAIL: Expected "FOR", to open a reference cursor.
> But what is a "reference cursor"? Isn't this rather saying "... to open a
> cursor, a reference to which will be stored in your variable"? Anyone got a
> better idea for a wording?
The documentation uses the phrase "unbound cursor". +1 for changing it
--- I don't see any other uses of "reference cursor", except in
pg_type.h where type "refcursor" is commented that way. And that should
probably read "reference to cursor".
regards, tom lane