These are features/bugfixes not yet on a stable version. You can try them by downloading the latest pre-releases on the GitHub release page.
Access Composite Type fields and Array elements
You can now access fields of a Composite type or elements of an Array type with the arrow operators(
->>) in the same way you would access the JSON type fields.
Improved Error Messages
To increase consistency, all the errors messages are now normalized. The
message fields will always be present in the body, each one defaulting to a
null value. In the same way, the errors that were raised with
SQLSTATE now include the
code in the body.
In addition to these changes and to further clarify the source of an error, PostgREST now adds a
PGRST prefix to the error code of all the errors that are PostgREST-specific and don’t come from the database. These errors have a unique code that identifies them and are documented in the PostgREST Error Codes section.
Alongside these changes, there is now a dedicated reference page for Error documentation.
Admins can now benefit from two health check endpoints exposed in a different port than the main app. When activated, the
ready endpoints are available to verify if PostgREST is alive and running or if the database connection and the schema cache are ready for querying.
You can now verify the current authenticated database user in the request log on stdout.
Run without configuration
It is now possible to execute PostgREST without specifying any configuration variable, even without the three that were mandatory
Added a Working with PostgreSQL data types how-to, which contains explanations and examples on how to work with different PostgreSQL data types such as timestamps, ranges or PostGIS types, among others.
Added in-database and environment variable settings for each configuration variable.
Added the File Descriptors subsection.
Moved the Casting type to custom JSON how-to to the Casting a Range to a JSON Object subsection.
Removed direct links for PostgREST versions older than 8.0 from the versions menu.
Removed the deprecated Embedding table from another schema how-to.
204 No Contentwithout
Clarify error for failed schema cache load. (#2107)
Database connection lost. Retrying the connectionto
Could not query the database for the schema cache. Retrying.
Fix silently ignoring filter on a non-existent embedded resource (#1771)
Remove functions, which are not callable due to unnamed arguments, from schema cache and OpenAPI output. (#2152)
Fix accessing JSON array fields with
204 No Contentwithout
Content-Typefor RPCs returning
Previously, those RPCs would return
nullas a body with
Big thanks from the PostgREST team to our sponsors!
If you like to join them please consider supporting PostgREST development.