v7.0.0¶
You can download this release at the PostgREST v7.0.0 release page.
Added¶
Support for Switching to a schema defined in db-schema.
– @steve-chavez, @mahmoudkassemSupport for Planned Count and Estimated Count.
– @steve-chavez, @LorenzHenkSupport for the on_conflict query parameter to UPSERT based on a unique constraint.
– @ykstSupport for Resource Embedding Disambiguation.
– @steve-chavezSupport for user defined socket permission via server-unix-socket-mode config option
– @DansvidaniaHTTP logic improvements – @steve-chavez
- Support for HTTP HEAD requests.
- GUCs for Accessing Request Path and Method.
- Support for Setting headers via pre-request.
- Allow overriding provided headers(Content-Type, Location, etc) by Setting Response Headers
- Access to the
Authorization
header value throughrequest.header.authorization
Documentation improvements
- Explanation for Schema Structure.
- Reference for Embedding on Stored Procedures.
- Reference for Embedding after Insertions/Updates/Deletions.
- Reference for filters on JSON Columns.
- How-to for Providing images for <img>.
- Added Community Tutorials section.
Fixed¶
- Allow embedding a view when its source table foreign key is UNIQUE
– @bwbroersma Accept: application/vnd.pgrst.object+json
behavior is now enforced for POST/PATCH/DELETE regardless ofPrefer: return=minimal
– @dwagin- Fix self join resource embedding on PATCH
– @herulume, @steve-chavez - Allow PATCH/DELETE without
Prefer: return=minimal
on tables with no SELECT privileges
– @steve-chavez - Fix many to many resource embedding for RPC/PATCH
– @steve-chavez
Changed¶
- Bulk Call should now be done by specifying a
Prefer: params=multiple-objects
header. This fixes a performance regression when calling stored procedures. - Resource Embedding now outputs an error when multiple relationships between two tables are found, see Embedding Disambiguation.
server-proxy-uri
config option has been renamed to openapi-server-proxy-uri.- Default Unix Socket file mode from 755 to 660
Thanks¶
This release was made possible thanks to:



- Daniel Babiak
- Evans Fernandes
- Jan Sommer
- Tsingson Qin
- Michel Pelletier
- Jay Hannah
- Robert Stolarz
- Kofi Gumbs
- Nicholas DiBiase
- Christopher Reid
- Nathan Bouscal
- Daniel Rafaj
- David Fenko
If you like to join them please consider supporting PostgREST development.