v14.1

Fixed

• Fix db-pre-config function failing when function names are pg reserved words by @taimoorzaeem in #4380
• Fix server-host=!6 incorrectly binds to IPv4 address by @taimoorzaeem in #3202

v14.0

Features

• Bounded JWT cache using the SIEVE algorithm by @mkleczek in #4084
  • Increases throughput of all requests having a JWT. 20% more throughput for GET requests according to our benchmarks.
  • Includes JWT Cache Metrics.
• Ready flag for postgrest healthcheck by @taimoorzaeem in #4239

Fixes

• Fix schema cache loading taking a long time for large schemas by @mkleczek in #4360, #3704
  • On a complex database, it goes down from 7 minutes to 2 seconds.
• Fix not logging OpenAPI queries when log-query is enabled by @steve-chavez in #4226
• Fix not logging explain query when log-query is enabled by @steve-chavez in #4319
• Fix not logging transaction variables and db-pre-request function when log-query is enabled by @steve-chavez in #3934
• Fix not logging the JSON message to stderr on a PGRST002 error by @laurenceisla in #4129
• Fix reloading the Schema Cache unnecessarily on a PGRST002 error by @laurenceisla in #4367

Breaking Changes

• Drop support for PostgreSQL EOL version 12 by @wolfgangwalther in #3865
• From now on PostgREST will follow a MAJOR.PATCH two-part versioning. Only even-numbered MAJOR versions will be released, reserving odd-numbered MAJOR versions for development.
• Replaced jwt-cache-max-lifetime config with jwt-cache-max-entries by @mkleczek in #4084
• log-query config now takes a boolean instead of a string value by @steve-chavez in #3934

v13.0.8

Fixed

• Fix loading utf-8 config files with ASCII locale set by @taimoorzaeem in #4386

v13.0.7

Added

• Improve the PGRST106 error when the requested schema is invalid by @laurenceisla in #4089
  • It now shows the invalid schema in the message field.
  • The exposed schemas are now listed in the hint instead of the message field.
• Improve error details of PGRST301 error by @taimoorzaeem in #4051

v13.0.6

Fixed

• Fix logging the Haskell type instead of the listener error message directly by @laurenceisla in #3588
• Fix format of IPv6 address logged at PostgREST startup by @taimoorzaeem in #4291
• Fix empty enum in preferParams OpenAPI parameter by @laurenceisla in #4292

v13.0.5

Fixed

• Fix OpenAPI broken docs link by @taimoorzaeem in #4048
• Fix OpenAPI specification incorrectly exposing GET methods for volatile functions by @joelonsql in #4174
• Fix empty spread embeddings return unexpected SQL error by @taimoorzaeem in #3887
• Fix /metrics endpoint not responding with Content-Type header by @taimoorzaeem in #4271

v13.0.4

Fixed

• Fix regression that makes full-text search not work on domain types based on tsvector by @laurenceisla in #4135
• Fix jwt-aud config not failing when set to an invalid URI by @taimoorzaeem in #4132

v13.0.3

Fixed

• Fix max-affected preference not failing with RPC when handling=strict by @taimoorzaeem in #4100
• Fix a property definition's type in OpenAPI not showing the correct base type of a recursive domain by @laurenceisla in #4136

v13.0.2

Fixed

• Fix regression that makes ORDER BY with nulls-order not work alongside limits by @laurenceisla in #4109

v13.0.1

Fixed

• Fix jwt error returning HTTP status 400 for invalid role by @taimoorzaeem in #3601
• Fix db-extra-search-path cannot be set to nothing by @taimoorzaeem in #4074
  • It can now be disabled by setting it to empty string.
  • Schema Cache load error is now logged including db-schemas and db-extra-search-path config values.