DELETE requires a WHERE clause #48

LaughingBubba · 2024-02-29T22:41:36Z

Hi, thanks for writing this package. I'm trying to delete all rows in a table (see below)

This:

  var results map[string]interface{}
  err := supabase.DB.From("events").Delete().Execute(&results)
  if err != nil {
    panic(err)
  }

Panics with this:

panic: 21000: DELETE requires a WHERE clause

It seems incongruous that this is required:

err := supabase.DB.From("events").Delete().Like("evt_name","*").Execute(&results)

When this just works in Postgres:

DELETE from events

Is this a bug or a feature or am I missing something?

Thanks in advance.

namzug16 · 2024-03-25T11:17:02Z

supabase-go is simply trying to mimic the original supabase APIs

as you can see here on their js docs a filter is always required when performing a DELETE

Provide feedback