org.postgresql:r2dbc-postgresql

⭐ New Features

• Handle protocol 3.2 dynamic secret key length. #708
• Add configurable limit for frame length. #714

🐞 Bug Fixes

• Reference-counting and concurrency issues in ReactorNettyClient. #717
• Truncate trailing bytes on SSL handshake. #705
• getRowsUpdated() empty for MERGE. #706
• Format.text() returns binary set. #707
• Int16 counts read signed (readShort). #709
• AuthenticationSASL decode peeks past buffer on empty/unterminated body. #710
• ReadyForQuery throws on unknown transaction-status byte. #711
• MessageType cache AIOOBE for byte 0x7F. #713

🐞 Bug Fixes

• Codec preference is not considered leading to OID value decoding through DayOfWeek #693

❤️ Contributors

We'd like to thank all the contributors who worked on this release!

• @turneand

⭐ New Features

• Expose API to subscribe to Postgres notice messages #570
• Add codecs for DayOfWeek, Month, MonthDay, Period, Year, YearMonth #591
• Make CodecMetadata.getDataTypes() more flexible #600
• Add PostgresqlResult.filter(…) overrides to return PostgresqlResult instead of Result #602
• Support for pgvector #612
• Add support for dynamic usernames and passwords #613
• Set SNI on SSL connections #634
• Performance issue with PostgresqlRow.getColumn(String name) when select many columns #636
• Defer oid and typarray to stage when an extension is supported #649
• Add support for sslnegotation=direct #651
• Introduce fast-path handling for decoding primitive values #662
• Introduce ObjectCodec to support bindNull(Object.class) #664
• Explore acquisition scheduler offloading #668
• Add JSpecify nullability annotations to Java APIs #689

🐞 Bug Fixes

• Cancel signal does not interrupt cursored query fetching #536
• Implement support for interval units. #566
• Error when storing BC dates (e.g. "0000-12-31T01:01:00Z") #578
• Creating connections can hang during server downtime #595
• Driver reports I/O error when rowsUpdated is greater than Integer.MAX_VALUE #597
• Do not require typarray column when auto-registering extensions #621
• NullPointerException at SingleHostConnectionFunction#getCredentials when configuration password is null #622
• Do not require typarray column when auto-registering extensions #632
• SNIHostName is going to throw an exception when hostname has a trailing dot #656
• Postgres 11 compatibility #657
• Fix self-suppression when standby is unavailable #678
• Include OID explicitly in the SELECT clause for older Postgres databases #680

💡 Other

• Remove rogue newline in readme #569
• Integration test fails on JDK > 8 because of Instant resolution change #572
• Bump Netty to 4.1.89.Final, CVE-2022-41915 #584
• Upgrade to Project Reactor 2022.0.3 #585
• key param javadoc description #593
• Adapt integration test to be Java 11 forward-compatible #594
• Upgrade to Reactor 2022.0.9 #604
• Bump org.postgresql:postgresql from 42.6.0 to 42.7.2 #637
• Resolve a LEAK warning in unit test #642
• Update SCRAM dependency to 3.0 #645
• Update scram-client to 3.1 #659
• Switch to Sonatype Central Publishing #681
• Bump com.ongres.scram:scram-common from 3.1 to 3.2 #682
• Upgrade to JTS 1.20.0 #688
• Ensure Java 8 ByteBufferAPI usage #690

❤️ Contributors

We'd like to thank all the contributors who worked on this release!

• @AntonioHReyes
• @HyunsangHan
• @ViddeM
• @arkbriar
• @chrischall
• @cty123
• @dependabot[bot]
• @emilwihlander
• @esin
• @fkomauli
• @frdeboffles
• @h1alexbel
• @hantsy
• @janainamendonca
• @jorsol
• @liemng
• @mateusz-baluch-xtb
• @mwinkels-bol
• @patriknw
• @pvlugter
• @seanmcnealy
• @skykatik
• @yuki-teraoka

• Cancel signal does not interrupt cursored query fetching #536
• Implement support for interval units. #566
• Bump postgresql from 42.5.0 to 42.5.1 #568
• Remove rogue newline in readme #569
• Expose API to subscribe to Postgres notice messages #570
• Integration test fails on JDK > 8 because of Instant resolution change #572
• Error when storing BC dates (e.g. "0000-12-31T01:01:00Z") #578
• Bump Netty to 4.1.89.Final, CVE-2022-41915 #584
• Upgrade to Project Reactor 2022.0.3 #585
• Add codecs for DayOfWeek, Month, MonthDay, Period, Year, YearMonth #591
• key param javadoc description #593
• Adapt integration test to be Java 11 forward-compatible #594
• Creating connections can hang during server downtime #595
• Driver reports I/O error when rowsUpdated is greater than Integer.MAX_VALUE #597
• Upgrade dependencies #599
• Make CodecMetadata.getDataTypes() more flexible #600
• Add PostgresqlResult.filter(…) overrides to return PostgresqlResult instead of Result #602
• Upgrade to Reactor 2022.0.9 #604
• Support for pgvector #612
• Add support for dynamic usernames and passwords #613
• Upgrade dependencies #616
• Do not require typarray column when auto-registering extensions #621
• NullPointerException at SingleHostConnectionFunction#getCredentials when configuration password is null #622
• Upgrade dependencies #628
• Do not require typarray column when auto-registering extensions #632
• README.md #633
• Set SNI on SSL connections #634
• Performance issue with PostgresqlRow.getColumn(String name) when select many columns #636
• Bump org.postgresql:postgresql from 42.6.0 to 42.7.2 #637
• Resolve a LEAK warning in unit test #642
• Update SCRAM dependency to 3.0 #645
• Defer oid and typarray to stage when an extension is supported #649
• Add support for sslnegotation=direct #651
• SNIHostName is going to throw an exception when hostname has a trailing dot #656
• Postgres 11 compatibility #657
• Update scram-client to 3.1 #659
• Introduce fast-path handling for decoding primitive values #662
• Introduce ObjectCodec to support bindNull(Object.class) #664
• Explore acquisition scheduler offloading #668
• Fix self-suppression when standby is unavailable #678
• Include OID explicitly in the SELECT clause for older Postgres databases #680
• Switch to Sonatype Central Publishing #681
• Bump com.ongres.scram:scram-common from 3.1 to 3.2 #682
• Upgrade to JTS 1.20.0 #688
• Add JSpecify nullability annotations to Java APIs #689
• Ensure Java 8 ByteBufferAPI usage #690

🐞 Bug Fixes

• Codec preference is not considered leading to OID value decoding through DayOfWeek #693

❤️ Contributors

We'd like to thank all the contributors who worked on this release!

• @turneand

⭐ New Features

• Add codecs for DayOfWeek, Month, MonthDay, Period, Year, YearMonth #591

🐞 Bug Fixes

• Fix self-suppression when standby is unavailable #678
• Include OID explicitly in the SELECT clause for older Postgres databases #680

💡 Other

• Switch to Sonatype Central Publishing #681

❤️ Contributors

We'd like to thank all the contributors who worked on this release!

• @HyunsangHan
• @hantsy
• @mateusz-baluch-xtb

• Add codecs for DayOfWeek, Month, MonthDay, Period, Year, YearMonth #591
• Fix self-suppression when standby is unavailable #678
• Include OID explicitly in the SELECT clause for older Postgres databases #680
• Switch to Sonatype Central Publishing #681

⭐ New Features

• Explore acquisition scheduler offloading #668

🐞 Bug Fixes

💡 Other

• Explore acquisition scheduler offloading #668

⭐ New Features

• Defer oid and typarray to stage when an extension is supported #649
• Introduce fast-path handling for decoding primitive values #662
• Introduce ObjectCodec to support bindNull(Object.class) #664

🐞 Bug Fixes

• SNIHostName is going to throw an exception when hostname has a trailing dot #656
• Postgres 11 compatibility #657

❤️ Contributors

We'd like to thank all the contributors who worked on this release!

• @AntonioHReyes
• @chrischall
• @seanmcnealy

• Defer oid and typarray to stage when an extension is supported #649
• SNIHostName is going to throw an exception when hostname has a trailing dot #656
• Postgres 11 compatibility #657
• Introduce fast-path handling for decoding primitive values #662
• Introduce ObjectCodec to support bindNull(Object.class) #664

⭐ New Features

• Set SNI on SSL connections #634
• Performance issue with PostgresqlRow.getColumn(String name) when select many columns #636

🐞 Bug Fixes

• Do not require typarray column when auto-registering extensions #632

💡 Other

• Resolve a LEAK warning in unit test #642

❤️ Contributors

We'd like to thank all the contributors who worked on this release!

• @arkbriar
• @chrischall
• @cty123
• @yuki-teraoka

• Do not require typarray column when auto-registering extensions #632
• Set SNI on SSL connections #634
• Performance issue with PostgresqlRow.getColumn(String name) when select many columns #636
• Resolve a LEAK warning in unit test #642

🐞 Bug Fixes

• Do not require typarray column when auto-registering extensions #621
• NullPointerException at SingleHostConnectionFunction#getCredentials when configuration password is null #622

💡 Other

• Upgrade dependencies #628

❤️ Contributors

We'd like to thank all the contributors who worked on this release!

• @janainamendonca

• Do not require typarray column when auto-registering extensions #621
• NullPointerException at SingleHostConnectionFunction#getCredentials when configuration password is null #622
• Upgrade dependencies #628

⭐ New Features

• Support for pgvector #612
• Add support for dynamic usernames and passwords #613

💡 Other

• Upgrade dependencies #616

❤️ Contributors

We'd like to thank all the contributors who worked on this release!

• @liemng

• Support for pgvector #612
• Add support for dynamic usernames and passwords #613
• Upgrade dependencies #616

• Cancel signal does not interrupt cursored query fetching #536
• Expose API to subscribe to Postgres notice messages #570
• key param javadoc description #593
• Adapt integration test to be Java 11 forward-compatible #594
• Creating connections can hang during server downtime #595
• Driver reports I/O error when rowsUpdated is greater than Integer.MAX_VALUE #597
• Add PostgresqlResult.filter(…) overrides to return PostgresqlResult instead of Result #602
• Upgrade to Reactor 2022.0.9 #604

• Associate PostgresConnectionClosedException with error code 08006 #538
• Bump postgresql from 42.4.0 to 42.4.1 #539
• Await ReadyForQuery before emitting errors from transactional control methods #541
• SRID not preserved in Geometry types (Point) since it is encoded as text using the WKTWriter #542
• Release 1.0.0.RELEASE #544
• Add GraalVM native reflection hints #549
• Allow StringCodec registration for CITEXT usage #551
• Upgrade to Reactor 2022.0.0 #554
• Fix LocalTimeCodec array OID #555
• Fix NumericDecodeUtils.decodeBinary(byteBuf) decoding #558
• Ensure buffer release on copyIn failure #560

• Support for Postgresql multi-host failover functionality #120
• Parameter values are not sent in the correct order #482
• Support for postgis geometry parent type #483
• Let Result.getRowsUpdated() return Long #484
• Remove deprecated RowMetadata.getColumnNames() method #485
• Consider lowercase sslmode for easier JDBC URL adaption #486
• Can't process CITEXT #488
• ReactorNettyClient requestProcessor can retain data from queries #492
• Update Readme as LOB types are already supported #493
• Upgrade to postgresql 42.3.3 #494
• Fix postgres OID type decoding #495
• Release 0.8.12.RELEASE #496
• Add COPY FROM support #500
• Upgrade to Reactor 2022.0.0-M1 #503
• Upgrade to Reactor 2022.0.0-M2 #506
• Upgrade to R2DBC 1.0 #508
• Issue parsing timestamp with timezone having offset of format +hh:mm:ss #509
• CachedCodecLookup wrongly assumes uniqueness of hashCode() #511
• Extend PostgresqlSqlLexer to handle PG14 SQL-standard function body syntax #512
• Upgrade to netty 4.1.77.Final to address epoll_wait() not implemented on Linux #514
• using an EnumCodec with no enums generates invalid SQL #515
• Add configuration for TimeZone #520
• Align LocalDate conversion to configured time zone #521

• Polishing #478

• Upgrade to R2DBC 0.9.0.RELEASE #473
• Adopt renamed TCK column name #472
• NumberFormatException in BuiltinDynamicCodecs when reading oid value #470
• Truncated the values tested in time-related unit tests to their micro… #469
• Lexing sql statements #468
• Move off deprecated Reactor Netty API #464
• Let Statement.add() always create a new binding set #463
• Use sequential processing in Result.flatMap(…) #462
• Buffers in SSLSessionHandlerAdapter not released after decoding #458
• Propagate offending SQL into R2DBC exceptions #457
• Align Statement.bind(…) and Readable.get(…) exceptions with specification #456
• Upgrade to R2DBC SPI 0.9 RC1 #455
• Add support to decode enums and other types as String #454
• SSL=False Option isn't working #453
• Upgrade dependencies #448
• Remove usage of java.security.AccessController #447
• Replace EmitterProcessor with Sinks API #445
• Introduce codec mapping caches (0.8.x branch) #444
• Updated rows from batch should not be aggregated #440
• Remove restriction on ending semicolon in ExtendedQueryPostgresStatement #439
• Avoid cast to X509Certificate array during certificate verification #438
• Add support for reading arbitrary enum values as String #429
• Introduce codec mapping caches #410
• Add support to re-prepare cached statements #382

• Invalid string formatting in PostgresTypes.lookupType #437
• Adding Extension from Option #433
• Upgrade to R2DBC SPI 0.9.0.M2 #425
• Add support for Result segment API #424
• Add Row.getMetadata() method #423
• Adapt to changed Option.getRequiredValue() return type #422
• PostgresObjectId#isValid uses exception as control mechanism resulting in significant performance penalty #420
• Memory Leak of BalancedResolverGroup #412
• Multi-byte characters inside HStore columns are not read correctly #407
• PG Bouncer tests fail with [08P01] password authentication failed #402
• Fetch rows never completes #401
• QueryLogger not used by ExtendedFlowDelegate #400
• Add BooleanArrayCodec, FloatArrayCodec, DoubleArrayCodec support #399
• Overflow Exception when fetchSize is set #395
• Can't bind Boolean[] types #394
• Introduce connection factory option for statementTimeout #381

• Upgrade to R2DBC SPI 0.9.0.M1 #388
• Upgrade to Reactor 2020.0.3 #380
• Add support for extended transaction definitions #379
• Add support for SPI Parameters #378
• Unable to insert a new entity in a table containing name "returning" #377
• Update license headers to report the inception year instead of start-end range #369
• Decoding CopyOutResponse message does not comply with postgres documentation #367
• Make JsonIntegrationTests extend AbstractIntegrationTests #364
• Upgrade to Testcontainers 1.15.0 #363
• Unable to decode array_agg(varchar) type. #361
• Remove travis build file as we no longer need travis-ci #359
• Map postgres' 40001 error code to PostgresqlRollbackException #355
• Add BigDecimal array codec #349
• Refactor dead if branch into single return flow #348
• Restrict CI and release task to pgjdbc/r2dbc-postgresql repo #347
• Add Interval Codec #345
• Upgrade dependencies #343
• Extended flow queries hang with pgpool 4.1 #341
• Replace casts to ByteBuffer after ByteBuffer.flip #340
• Introduce connection context to allow correlation of log statements to the actual connection #339
• Use RoundRobinInetAddressResolver for DNS resolution #338
• RowMetadata.getColumnNames() iteration order doesn't match result set column order #337
• Add UUID array codec #336
• Occasional delays caused by TCP NoDelay config option defaulting to false #334
• Upgrade to R2DBC SPI 0.8.3 #333
• Use detached byte buffers by default for decoded values #330
• JsonCodec.encode(…) doesn't release input buffer #329
• Upgrade to Assertj 3.17.2 #328
• Upgrade to Netty 4.1.51.Final #327
• Upgrade to Reactor Dysprosium SR11 #326
• Use GitHub actions to deploy to OSS Sonatype/Maven Central #325
• Issue parsing UTC timestamptz from CockroachDB #320
• Possibility to configure LoopResources inside ReactorNettyClient #319
• Accept SSL certificates by providing a URL to use cert from within a jar #313
• Add priority to EnumCodec registrar #310
• EnumCodec's canDecode method fix (Issue #302) #308
• Support for geospatial types - point, line, box, polygon etc #306
• NullPointerExceptionwhen adding SSL handler via SSLTunnelHandlerAdapter #304
• Add priority to EnumCodec registrar #303
• EnumCodec decoding fails if the requested value type is Object #302
• Row.decode(…) fails for enum type with IllegalArgumentException: 72093 is not a valid object id #301
• Ensure no snapshots get referenced in release builds #299
• Add config options for TCP nodelay and keepalive #296
• Add support for SSL tunnels #295
• Support for "time with time zone" type #294
• Query doesn't complete #292
• Upgrade to Reactor Dysprosium SR9 #291
• Rename master branch to main #290
• Upgrade to Reactor Dysprosium SR8 #289
• Move repository to pgjdbc organization #287
• SSL Mode configuration is not working anymore with v0.8.3.RELEASE #286
• Infinite drainLoop call in BackendMessageSubscriber #285
• Add support for point type #283
• Support for geospatial types - point, line, box, polygon etc #282
• Upgrade dependencies #281
• Introduce OptionMapper for option mapping #279
• add capability to log query parameters (bindings) values #278
• Add BlockHound to integration tests #276
• static initializers of StartupMessage cause blocking calls #275
• Connection in unstable state when rollback after a failed commit #274
• adds capability to specify connections options via URL #273
• add support for providing "search_path" connection option #271
• Fix typo #270
• Support hstore as default codec #268
• Upgrade build plugin and test dependencies #266
• Upgrade to netty 4.1.47.Final #265
• Upgrade to Reactor Dysprosium-SR6 #264
• Upgrade to testcontainers 1.13.0 #261
• Stage releases directly on maven central #259
• Default fetch size #256
• IllegalStateException when reading empty byte array #253
• Allow configuration of ErrorResponse and NoticeResponse logging #249
• Canceling requests in progress with CancelRequest #246
• Fetch size implementation #245
• Add codec for Postgres enumerated types #244
• Add fast-path emission of incoming frames #243
• High CPU usage when cancelled query #242
• Allow configuration of ErrorResponse and NoticeResponse logging #239
• Update license header years to 2020 #236
• Add a codec for BigInteger #233
• Reinstantiate backpressure propagation to NettyInbound #231
• Fix for concurrent exchanging on one client #230
• Add support for RefCursor #229
• Terminate Notification stream on disconnect #227
• Capability to disable prepared statement caching #223
• Insertion of too many rows do not complete #222
• Upgrade to Testcontainers 1.12.4 #218
• Enable Travis for pull requests #214
• Migrate to Jenkins CI #213
• On error not triggered when listen connection terminated #212
• Simplify factory provider #210
• Fails to startup with forceBinary=true using Spring Boot #208
• rowsUpdated() returns more than one item. #207
• Readme cleanup #206
• Fix typo in project url #205
• Enable consumption of REFCURSOR #173
• Combine extended flow messages into a single composite message #138
• Send cancelation packet to Postgres server in order to interrupt running query #121

• Allow configuring auto-commit mode through properties #194
• Enable Developer Certificate of Origin #193
• Restrict CI and release task to r2dbc/r2dbc-spi repo #191
• Upgrade dependencies #188
• Extend TCK for RowMetadata.getColumnNames() iteration order #187
• Deploy snapshots to oss.sonatype.org #186
• Database password ends with special characters like '@' causes incorrectly parsing. #183
• Typo in Row.get(…) Javadoc #182
• Add a method to unwrap to the specified class from nested wrapped object #176
• Upgrade dependencies #172
• Add equals/hashCode implementation to ConnectionFactoryOptions and Option #166
• Upgrade build and test dependencies #165
• Stage releases directly on maven central #163
• Consider removing or replacing the word "should" #161
• Improved bind-parameter declaration #160
• Extensible transaction definition #159
• Result consuming in TestKit fix #154
• Use Travis CI to build pull requests #148
• Migrate to Jenkins #145
• Allow query syntax customization in TCK TestKit #138
• Document backpressure behavior related to fetching results #137
• Specific exception for retrieving missing required values from ConnectionFactoryOptions #122