problem on deletion

[PhilemonChiro]

when deleting rooms or messages i get this error below, please remove the limit or add order to the supabase method, please fix soon its affecting my app

E/flutter (32298): [ERROR:flutter/runtime/dart_vm_initializer.cc(41)] Unhandled Exception: PostgrestException(message: A 'limit' was applied without an explicit 'order', code: PGRST109, details: Bad Request, hint: Apply an 'order' using unique column(s))
E/flutter (32298): #0 PostgrestBuilder._parseResponse (package:postgrest/src/postgrest_builder.dart:299:7)
E/flutter (32298): #1 PostgrestBuilder._execute (package:postgrest/src/postgrest_builder.dart:174:14)
E/flutter (32298):
E/flutter (32298): #2 PostgrestBuilder.then (package:postgrest/src/postgrest_builder.dart:397:24)
E/flutter (32298):
E/flutter (32298):