Delete all query

[PLLX76]

Hello, this is to know if it was possible to delete all the data in a table because it causes an error. My code :

supabase.table("messages").delete().execute()

And my error

APIError: {'code': '21000', 'details': None, 'hint': None, 'message': 'DELETE requires a WHERE clause'}

thank you in advance for your response

[J0]

Hey!

We don't support this both in the Python and the JS lib. It is allowed if you directly query Postgres but we recommend using filters.

The workaround is to use an rpc call (which we're fixing right now)

Going to close but let me know if there are further issues. Thanks!