Added

• #3558, Add the admin-server-host config to set the host for the admin server - @develop7
• #3607, Log to stderr when the JWT secret is less than 32 characters long - @laurenceisla
• #2858, Performance improvements when calling RPCs via GET using indexes in more cases - @wolfgangwalther
• #3560, Log resolved host in "Listening on ..." messages - @develop7
• #3727, Log maximum pool size - @steve-chavez
• #1536, Add string comparison feature for jwt-role-claim-key - @taimoorzaeem
• #3747, Allow not_null value for the is operator - @taimoorzaeem
• #2255, Apply to_tsvector() explicitly to the full-text search filtered column (excluding tsvector types) - @laurenceisla
• #1578, Log the main SQL query to stderr at the current log-level when log-query=main-query - @laurenceisla
• #3903, Log connection pool borrows on log-level=debug - @taimoorzaeem
• #3041, Allow spreading one-to-many and many-to-many embedded resources - @laurenceisla
  • The selected columns in the embedded resources are aggregated into arrays
  • Aggregates are not supported
• #2967, Add Proxy-Status header for better error response - @taimoorzaeem
• #4016, Add Content-Length response header - @laurenceisla

Fixed

• #3693, Prevent spread embedding to allow aggregates when they are disabled - @laurenceisla
• #3693, A nested spread embedding now correctly groups by the fields of its top parent relationship - @laurenceisla
• #3693, Fix spread embedding errors when using the count() aggregate without a field - @laurenceisla
  • Fixed "column reference <col> is ambiguous" error when selecting ?select=...table(col,count())
  • Fixed "column <json_aggregate>.<alias> does not exist" error when selecting ?select=...table(aias:count())
• #3727, Clarify "listening" logs - @steve-chavez
• #3795, Clarify Accept: vnd.pgrst.object error message - @steve-chavez
• #3697, #3602, Handle queries on non-existing table gracefully - @taimoorzaeem
• #3600, #3926, Improve JWT errors - @taimoorzaeem
• #3013, Fix order= with POST, PATCH, PUT and DELETE requests - @taimoorzaeem

Changed

• #2052, Dropped support for PostgreSQL 9.6 - @wolfgangwalther
• #2052, Dropped support for PostgreSQL 10 - @wolfgangwalther
• #2052, Dropped support for PostgreSQL 11 - @wolfgangwalther
• #3508, PostgREST now fails to start when server-port and admin-server-port config options are the same - @develop7
• #3607, PostgREST now fails to start when the JWT secret is less than 32 characters long - @laurenceisla
• #3644, Fail schema cache lookup with invalid db-schemas config - @wolfgangwalther
  • Previously, this would silently return 200 - OK on the root endpoint, but don't provide any usable endpoints.
• #3757, Remove support for Prefer: params=single-object - @joelonsql
  • This preference was deprecated in favor of Functions with an array of JSON objects
• #3013, Drop support for Limited updates/deletes
  • The feature was complicated and largely unused.
• #3697, #3602, Querying non-existent table now returns PGRST205 error instead of empty json - @taimoorzaeem
• #3600, #3926, Improve JWT errors - @taimoorzaeem
  • Return PGRST301 error when Bearer in auth header is sent empty
  • Diagnostic error messages instead of exposed internals
  • Return new PGRST303 error when jwt claims decoding fails
• #3906, Return PGRST125 and PGRST126 errors instead of empty json - @taimoorzaeem

Fixed

• #4030, Fix regression with parameter charset=utf-8 in mediatype - @taimoorzaeem

Fixed

• #3889, Fix: JWT cache purging on every request decreases performance - @mkleczek

Fixed

• #3498, Fix incorrect parsing of the for parameter of the application/vnd.pgrst.plan media type - @taimoorzaeem
• #4014, Fix JWT cache allows old tokens after the jwt-secret is changed in a config reload - @taimoorzaeem

Fixed

• #3841, Log 503 client error to stderr - @taimoorzaeem

Fixed

• #2524, Fix schema reloading notice on windows - @diogob

Fixed

• #3788, Fix jwt cache does not remove expired entries - @taimoorzaeem

Fixed

• #3867, Fix startup for arm64 docker image - @wolfgangwalther

Fixed

• #3779, Always log the schema cache load time - @steve-chavez
• #3706, Fix insert with missing=default uses default value of domain instead of column - @taimoorzaeem

Fixed

• #3091, Broken link in OpenAPI description externalDocs - @salim-b
• #3659, Embed One-to-One relationship with different column order properly - @wolfgangwalther
• #3504, Remove format from rowFilter parameters in OpenAPI - @dantheman2865
• #3660, Fix regression that loaded the schema cache before the in-database configuration - @steve-chavez, @laurenceisla