PostgREST/postgrest v9.0.0

on GitHub

Added

• #1783, Include partitioned tables into the schema cache. Allows embedding, UPSERT, INSERT with Location response, OPTIONS request and OpenAPI support for partitioned tables - @laurenceisla
• #1878, Add Retry-After hint header when in recovery mode - @gautam1168
• #1735, Allow calling function with single unnamed param through RPC POST. - @steve-chavez
  • Enables calling a function with a single json parameter without using Prefer: params=single-object
  • Enables uploading bytea to a function with Content-Type: application/octet-stream
  • Enables uploading raw text to a function with Content-Type: text/plain
• #1938, Allow escaping inside double quotes with a backslash, e.g. ?col=in.("Double\"Quote"), ?col=in.("Back\\slash") - @steve-chavez
• #1075, Allow filtering top-level resource based on embedded resources filters. This is enabled by adding !inner to the embedded resource, e.g. /projects?select=*,clients!inner(*)&clients.id=eq.12- @steve-chavez, @Iced-Sun
• #1857, Make GUC names for headers, cookies and jwt claims compatible with PostgreSQL v14 - @laurenceisla, @robertsosinski
  • Getting the value for a header GUC on PostgreSQL 14 is done using current_setting('request.headers')::json->>'name-of-header' and in a similar way for request.cookies and request.jwt.claims
  • PostgreSQL versions below 14 can opt in to the new JSON GUCs by setting the db-use-legacy-gucs config option to false (true by default)
• #1988, Allow specifying unknown for the is operator - @steve-chavez
• #2031, Improve error message for ambiguous embedding and add a relevant hint that includes unambiguous embedding suggestions - @laurenceisla

Fixed

• #1871, Fix OpenAPI missing default values for String types and identify Array types as "array" instead of "string" - @laurenceisla
• #1930, Fix RPC return type handling for RETURNS TABLE with a single column. Regression of #1615. - @wolfgangwalther
• #1938, Fix using single double quotes(") and backslashes(/) as values on the "in" operator - @steve-chavez
• #1992, Fix schema cache query failing with standard_conforming_strings = off - @wolfgangwalther

Changed

• #1949, Drop support for embedding hints used with .(e.g. select=projects.client_id(*)), ! should be used instead(e.g. select=projects!client_id(*)) - @steve-chavez
• #1783, Partitions (created using PARTITION OF) are no longer included in the schema cache. - @laurenceisla
• #2038, Dropped support for PostgreSQL 9.5 - @wolfgangwalther