Cant delete more than 100 rows from supabase dashboard?

I have 2 questions:
I am trying to delete all selected rows from my table, but I get this error:

Failed to run sql query: cannot truncate a table referenced in a foreign key constraint

Failed to run sql query: cannot truncate a table referenced in a foreign key constraint

Failed to run sql query: cannot truncate a table referenced in a foreign key constraint

Failed to run sql query: cannot truncate a table referenced in a foreign key constraint

Another question is - how do I reset the row count back to 1?

jxyz•9/21/22, 5:44 PM

maybe cascade? the foreign key constraint is a nice hint hehe

Jjxyz maybe cascade? the foreign key constraint is a nice hint hehe

LukasVOP•9/21/22, 5:55 PM

What does cascade mean haha? I just want to delete it

garyaustin•9/21/22, 6:24 PM

You can't delete a row in a table if there is foreign key in another table pointing to it. You have to delete the other row (or make the foreign key null) first.

There is a way to automatically delete the rows in the other table. It is discussed here how to change the constraint to cascade delete for tables created in the UI.
https://github.com/supabase/supabase/discussions/3075

GitHub

Cascade Delete js · Discussion #3075 · supabase/supabase

Is it possible to perform cascade deletion from Supbase UI and also from withing javascript?? Or do I have to make some SQL ?

Cant delete more than 100 rows from supabase dashboard?

Similar Threads

Similar Threads

Similar Threads