v8.0.0

You can download this release at the PostgREST v8.0.0 release page.

Added

• Allow HTTP status override through the response.status GUC.
  – @steve-chavez

• Allow Calling variadic functions.
  – @wolfgangwalther

• Allow Embedding Chains of Views recursively to any depth.
  – @wolfgangwalther

• No downtime when reloading the schema cache. See Schema Cache Reloading.
  – @steve-chavez

• Allow schema cache reloading using PostgreSQL NOTIFY command. This enables Automatic Schema Cache Reloading.
  – @steve-chavez

• Allow sending the header Prefer: headers-only to get a response with a Location header. See Insertions.
  – @laurenceisla

• Allow Using External Connection Poolers such as PgBouncer in transaction pooling mode.
  – @laurenceisla

• Allow Configuration Reloading by sending a SIGUSR2 signal.
  – @steve-chavez

• Allow Bearer with and without capitalization as authentication schema. See Client Auth.
  – @wolfgangwalther

• In-Database Configuration that can be reloaded with NOTIFY.
  – @steve-chavez

• Allow OPTIONS to generate HTTP methods based on views triggers. See OPTIONS requests.
  – @laurenceisla

• Show timestamps for server diagnostic information. See Logging.
  – @steve-chavez

• Config options for showing a full OpenAPI output regardless of the JWT role privileges and for disabling it altogether. See openapi-mode.
  – @steve-chavez

• Config option for logging level. See log-level.
  – @steve-chavez

• Config option for enabling or disabling prepared statements. See db-prepared-statements.
  – @steve-chavez

• Config option for specifying how to terminate the transactions (allowing rollbacks, useful for testing). See db-tx-end.
  – @wolfgangwalther

• Documentation improvements

  • Added the Schema Cache page.

  • Moved the Schema Cache Reloading reference from Hardening PostgREST to Schema Cache

Changed

• Docker images are now optimized to be built from the scratch image. This reduces the compressed image size from over 30 MB to about 4 MB. For more details, see Docker image built with Nix.
  – @monacoremo

• The Docker image no longer has an internal /etc/postgrest.conf file, you must use Environment Variables to configure it.
  – @wolfgangwalther

• The pg_listen utility is no longer needed to automatically reload the schema cache and it’s replaced entirely by database notifications. See Automatic Schema Cache Reloading.
  – @steve-chavez

• POST requests for insertions no longer include a Location header in the response by default and behave the same way as having a Prefer: return=minimal header in the request. This prevents permissions errors when having a write-only table. See Insertions.
  – @laurenceisla

• Modified the default logging level from info to error. See log-level.
  – @steve-chavez

• Changed the error message for a not found RPC on a stale schema (see Stale Function Signature) and for the unsupported case of overloaded functions with the same argument names but different types.
  – @laurenceisla

• Changed the error message for the no relationship found error. See Stale Foreign Key Relationships.
  – @laurenceisla

Fixed

• Fix showing UNKNOWN on postgrest --help invocation.
  – @monacoremo

• Removed single column restriction to allow composite foreign keys in join tables.
  – @goteguru

• Fix expired JWTs starting an empty transaction on the db.
  – @steve-chavez

• Fix location header for POST request with select= without PK.
  – @wolfgangwalther

• Fix error messages on connection failure for localized PostgreSQL on Windows.
  – @wolfgangwalther

• Fix application/octet-stream appending charset=utf-8.
  – @steve-chavez

• Fix overloading of functions with unnamed arguments.
  – @wolfgangwalther

• Return 405 Method not Allowed for GET of volatile RPC instead of 500.
  – @wolfgangwalther

• Fix RPC return type handling and embedding for domains with composite base type.
  – @wolfgangwalther

• Fix embedding through views that have COALESCE with subselect.
  – @wolfgangwalther

• Fix parsing of boolean config values for Docker environment variables, now it accepts double quoted truth values ("true", "false") and numbers ("1", "0").
  – @wolfgangwalther

• Fix using app.settings.xxx config options in Docker, now they can be used as PGRST_APP_SETTINGS_xxx.
  – @wolfgangwalther

• Fix panic when attempting to run with unix socket on non-unix host and properly close unix domain socket on exit.
  – @monacoremo

• Disregard internal junction (in non-exposed schema) when embedding.
  – @steve-chavez

• Fix requests for overloaded functions from HTML forms to no longer hang.
  – @laurenceisla

Thanks

Big thanks from the PostgREST team to our sponsors!

• Evans Fernandes

• Jan Sommer

• Franz Gusenbauer

• Daniel Babiak

• Tsingson Qin

• Michel Pelletier

• Jay Hannah

• Robert Stolarz

• Nicholas DiBiase

• Christopher Reid

• Nathan Bouscal

• Daniel Rafaj

• David Fenko

• Remo Rechkemmer

• Severin Ibarluzea

• Tom Saleeba

• Pawel Tyll

If you like to join them please consider supporting PostgREST development.