Hello,
We also get the error with the latest (3.4.4) dbexpress driver.
This is our create table script (column names shouldn't matter so I left them in Dutch):
create table mytable (
dnkey serial,
dvnaam varchar(200),
dvtussenvoegsel varchar(10),
dvvoorletters varchar(10),
....
;
alter table mytable
add constraint cpk_mytable
primary key (dnkey)
;
log file created with with options
log_statement and log_connection set to true.
server is 8.0 running on Windows 2000
2014-01-20 12:05:48 LOG: database system is ready
2014-01-20 12:07:02 LOG: connection received: host=192.168.xx.yy port=8686
2014-01-20 12:07:02 LOG: connection authorized: user=myuser database=mydb
2014-01-20 12:07:02 LOG: statement: SELECT VERSION()
2014-01-20 12:07:02 LOG: statement: show integer_datetimes
2014-01-20 12:07:02 LOG: statement: SET search_path TO public
2014-01-20 12:07:02 LOG: statement: SELECT dnkey, dvnaam, dvtussenvoegsel, dvoorletters FROM mytable
[after our query the dbexpress driver sends the following query...]
2014-01-20 12:07:02 LOG: statement: SELECT current_database() AS TABLE_CATALOG, n.nspname AS TABLE_SCHEMA, t.relname AS TABLE_NAME, t.oid AS TABLE_OID, current_database() AS INDEX_CATALOG, n.nspname AS INDEX_SCHEMA, c.relname AS INDEX_NAME, c.oid AS INDEX_OID, a.attname AS COLUMN_NAME, a.attnum AS COLUMN_POSITION, 0 AS DESCENDING , CASE WHEN i.indisunique=TRUE THEN 1 ELSE 0 END AS UNIQUE FROM pg_index i INNER JOIN pg_class c ON c.oid = i.indexrelid INNER JOIN pg_class t ON t.oid = i.indrelid INNER JOIN pg_namespace n ON n.oid = t.relnamespace INNER JOIN pg_attribute a ON a.attrelid = i.indrelid AND a.attnum = any (i.indkey) WHERE n.nspname LIKE 'public' AND t.relname LIKE 'mytable' ORDER BY indisprimary::integer DESC, n.nspname, t.relname, c.relname, a.attnum
2014-01-20 12:07:02 ERROR: op ANY/ALL (array) requires array on right side
[after this I got an OleException(!) "DBX Error: Error code 65535", and so many errors in our application that I had to kill it, so I guess the next log messages can be ignored]
2014-01-20 12:07:06 LOG: unexpected EOF on client connection
2014-01-20 12:07:06 LOG: disconnection: session time: 0:00:03.96 user=myuser database=mydb host=192.168.xx.yy port=8686
I hope you could investigate for the latest driver, please let me know if you need more info