Re: ERROR: cursor variable must be a simple variable (LINE XX: OPEN vQuery.cursorReturn FOR )

On Thu, Apr 28, 2022 at 8:03 AM Burke, William J Collins <
William(dot)Burke(at)collins(dot)com> wrote:

> Hello,
>
>
>
> I encountered the following error when compiling a pgsql function after an
> upgrade from PostgresSQL 9.3 on RHEL7 to PostgreSQL 12.9 on RHEL8, and
> could use some help from the community to figure out why.
>
>
>
> ERROR: cursor variable must be a simple variable
>
> LINE XX: OPEN vQuery.cursorReturn FOR
>
> ^
>
> SQL state: 42804
>
>
>
> After looking through the CURSOR documentation for PG9.3 and PG12, I
> noticed that the following statement is identical for both versions of
> PostgreSQL:
>
>
>
Per testing on db-fiddle this started reporting an error in v11.

I took a peek but didn't see anything directly affecting this; but quite a
bit of technical debt repayment happened that cycle and since the current
behavior matches the documentation, and there were/are no test cases for
this situation, the behavior change isn't surprising.

I'd accept a bug and backpatch solution here, though, if someone wished to
write one. We currently support a version (10) that allows this code to
execute, seemingly without issue.

David J.