Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, Apr 28, 2022 at 8:03 AM Burke, William J Collins <William.Burke@xxxxxxxxxxx> 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.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux