« Changelog History


postgrest v9.0.0 Release Notes

Release Date: 2021-11-25 // over 2 years ago

  • ➕ 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 '.'(select=projects.client_id(*)), '!' should be used instead(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