Avoid case sensitive access to PgDatabaseMetaData columns due to regressions after driver version 42.7.5 #17873
Description
Expected behavior
No response
Actual behavior
When I update postgresql jdbc drive to 42.7.5 code generator throws exception:
Caused by: java.lang.IllegalArgumentException: Field "key_seq" is not contained in row type (
"PKTABLE_CAT",
"pg_namespace"."PKTABLE_SCHEM",
"pg_class"."PKTABLE_NAME",
"pg_attribute"."PKCOLUMN_NAME",
"FKTABLE_CAT",
"pg_namespace"."FKTABLE_SCHEM",
"pg_class"."FKTABLE_NAME",
"pg_attribute"."FKCOLUMN_NAME",
"KEY_SEQ",
"UPDATE_RULE",
"DELETE_RULE",
"pg_constraint"."FK_NAME",
"pg_class"."PK_NAME",
"DEFERRABILITY"
)
Steps to reproduce the problem
Upgrade your postgresql jdbc driver to 42.7.5
jOOQ Version
JOOQ free 3.19.17
Database product and version
PostgreSQL 16
Java Version
zulu 22.0.2
JDBC / R2DBC driver name and version (include name if unofficial driver)
org.postgresql:postgresql:42.7.5