Обсуждение: plpgsql error message

Поиск
Список
Период
Сортировка

plpgsql error message

От
Peter Eisentraut
Дата:
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?


Re: plpgsql error message

От
Tom Lane
Дата:
Peter Eisentraut <peter_e@gmx.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