thanks il have a try its weird because it was working fine the first way I had it the other day

Did you happen to have RLS on before? Sort of wondering if that would count as a where....

I did (I think) I didn’t touch this project for to long. il put it back on and see if it makes a difference. I just looked at my git history and it definitely didn’t have a match before

Either way I would keep some sort of filter on it. Your update should not rely on just RLS to pick the record in case you change RLS and forget about it.

Projects now come with the https://github.com/eradman/pg-safeupdate extension enabled by default. This is to prevent accidental full table delete/updates through the API. You can still do full table deletes on the SQL Editor if you wish to.

makes sense thanks @User