PostgreSQL version: 16.4
Operating system: Microsoft Windows 10 Enterprise Version 10.0.19044
SQLGetInfo with SQL_DBMS_NAME says version 16.0.4 though
Driver PSQLODBC35W.DLL version 13.02.0000
This error occurs only with some statements when using binding parameters
through ODBC
This statement is an example of when the error occurs
SELECT "Id","Begin","End","Logfile" FROM "ServerSession" ORDER BY "Begin" ASC OFFSET ? ROWS FETCH FIRST ? ROW ONLY
but some more complex SQL statements (with `... OFFSET ? ROWS FETCH FIRST ? ROW ONLY`) works just fine
Having fixed values (e.g. `...OFFSET 100 ROWS FETCH FIRST 10 ROW ONLY`) works for all statements
I still haven't figured out the pattern what the differences really are that make some statements to work and some not to work (I haven't dug into the open source code at all (yet))
/ Kristian
p.s.