Compatibility/Bug in r2dbc-postgresql v1.0.5 due to performance tuning

[markus-arndt-fioneer]

Versions

• Driver: Postgresql 42.6.2
• Database: PostgreSQL 11.22 (fully managed on Azure)
• Java: 17
• OS: Arch Linux

Current Behavior

After we have upgraded from Spring Boot 3.2.4 to Spring Boot 3.2.10 / from r2dbc-postgres 1.0.4 to r2dbc-postgres 1.0.5 we are seeing Exceptions from PostgresqlRowMetadata.java::getColumn which was performance tuned in that release.

• Buggy Release: https://github.com/pgjdbc/r2dbc-postgresql/releases/tag/v1.0.5.RELEASE
• Issue that introduced the Bug: Performance issue with PostgresqlRow.getColumn(String name) when select many columns #636
• Buggy PR: 079b565

The exceptions we see are:

PostgresqlConnectionFactory.java (caused by Exception below)

Caused by: io.r2dbc.postgresql.PostgresqlConnectionFactory$PostgresConnectionException: Cannot connect to 4.180.61.180/<unresolved>:5432
at io.r2dbc.postgresql.PostgresqlConnectionFactory.cannotConnect(PostgresqlConnectionFactory.java:188)
at io.r2dbc.postgresql.PostgresqlConnectionFactory.lambda$doCreateConnection$7(PostgresqlConnectionFactory.java:153)

PostgresqlRow.java (this was performance tuned)

Caused by: java.util.NoSuchElementException: Column name 'oid' does not exist in column names [typname, typnamespace, typowner, typlen, typbyval, typtype, typcategory, typispreferred, typisdefined, typdelim, typrelid, typelem, typarray, typinput, typoutput, typreceive, typsend, typmodin, typmodout, typanalyze, typalign, typstorage, typnotnull, typbasetype, typtypmod, typndims, typcollation, typdefaultbin, typdefault, typacl]
at io.r2dbc.postgresql.PostgresqlRow.getColumn(PostgresqlRow.java:193)
at io.r2dbc.postgresql.PostgresqlRow.get(PostgresqlRow.java:96)
at io.r2dbc.postgresql.codec.BuiltinDynamicCodecs.lambda$null$0(BuiltinDynamicCodecs.java:107)
at io.r2dbc.postgresql.PostgresqlResult.lambda$map$2(PostgresqlResult.java:129)
at reactor.core.publisher.FluxHandleFuseable$HandleFuseableSubscriber.onNext(FluxHandleFuseable.java:179)
... 60 common frames omitted\n

[mp911de]

This is a duplicate of #657