PostgREST / postgrest

REST API for any Postgres database
https://postgrest.org
MIT License
23.48k stars 1.03k forks source link

Delete ignores resource embedding with top level filtering #3638

Open ewan-escience opened 4 months ago

ewan-escience commented 4 months ago

When deleting using resource embedding with top level filtering, the top level filtering is not applied when determining what rows to delete. I would expect this to be the case, i.e. I would expect only the same rows to be deleted that I would see when doing the same GET request.

wolfgangwalther commented 4 months ago

Hmm... I think this might be very hard to impossible to do with the way we create those queries.

PATCH / UPDATE probably has the same problem.