github PostgREST/postgrest v8.0.0

latest releases: v10.2.0.20230209, v10.2.0.20230203, v10.1.2...
20 months ago



  • #1592, Removed single column restriction to allow composite foreign keys in join tables - @goteguru
  • #1530, Fix how the PostgREST version is shown in the help text when the .git directory is not available - @monacoremo
  • #1094, Fix expired JWTs starting an empty transaction on the db - @steve-chavez
  • #1162, Fix location header for POST request with select= without PK - @wolfgangwalther
  • #1585, Fix error messages on connection failure for localized postgres on Windows - @wolfgangwalther
  • #1636, Fix application/octet-stream appending charset=utf-8 - @steve-chavez
  • #1469, #1638 Fix overloading of functions with unnamed arguments - @wolfgangwalther
  • #1560, Return 405 Method not Allowed for GET of volatile RPC instead of 500 - @wolfgangwalther
  • #1584, Fix RPC return type handling and embedding for domains with composite base type (#1615) - @wolfgangwalther
  • #1608, #1635, Fix embedding through views that have COALESCE with subselect - @wolfgangwalther
  • #1572, Fix parsing of boolean config values for Docker environment variables, now it accepts double quoted truth values ("true", "false") and numbers("1", "0") - @wolfgangwalther
  • #1624, Fix using config options in Docker, now they can be used as PGRST_APP_SETTINGS_xxx - @wolfgangwalther
  • #1814, Fix panic when attempting to run with unix socket on non-unix host and properly close unix domain socket on exit - @monacoremo
  • #1825, Disregard internal junction(in non-exposed schema) when embedding - @steve-chavez
  • #1846, Fix requests for overloaded functions from html forms to no longer hang (#1848) - @laurenceisla
  • #1858, Add a hint and clarification to the no relationship found error - @laurenceisla
  • #1841, Show comprehensive error when an RPC is not found in a stale schema cache - @laurenceisla
  • #1875, Fix Location headers in headers only representation for null PK inserts on views - @laurenceisla


  • #1522, #1528, #1535, Docker images are now built from scratch based on a the static PostgREST executable (#1494) and with Nix instead of a Dockerfile. This reduces the compressed image size from over 30mb to about 4mb - @monacoremo
  • #1461, Location header for POST request is only included when PK is available on the table - @wolfgangwalther
  • #1560, Volatile RPC called with GET now returns 405 Method not Allowed instead of 500 - @wolfgangwalther
  • #1584, #1849 Functions that declare returns composite_type no longer return a single object array by default, only functions with returns setof composite_type return an array of objects - @wolfgangwalther
  • #1604, Change the default logging level to log-level=error. Only requests with a status greater or equal than 500 will be logged. If you wish to go back to the previous behaviour and log all the requests, use log-level=info - @steve-chavez
    • Because currently there's no buffering for logging, defaulting to the error level(minimum logging) increases throughput by around 15% for simple GET queries(no embedding, with filters applied).
  • #1617, Dropped support for PostgreSQL 9.4 - @wolfgangwalther
  • #1679, Renamed config settings with fallback aliases. e.g. max-rows is now db-max-rows, but max-rows is still accepted - @wolfgangwalther
  • #1656, Allow Prefer=headers-only on POST requests and change default to minimal (#1813) - @laurenceisla
  • #1854, Dropped undocumented support for gzip compression (which was surprisingly slow and easily enabled by mistake). In some use-cases this makes Postgres up to 3x faster - @aljungberg
  • #1872, Send startup/worker logs to stderr to differentiate from access logs on stdout - @steve-chavez

Don't miss a new postgrest release

NewReleases is sending notifications on new releases.