Failure On Update Statement
I found the issue when try to update some data. I try it with different ways.
When i try using Db eaver to access db with port 5432 and 6543 to execute update statement it will return timeout. But if execute the select or insert statement it will run normally.
I think it cause my db manager, then i try direct from supabase sql editor. Then it happen too.
Pls help 🙂
5 Replies
Do you have an update trigger function on that table?
No, im not updating the function. But can we see the log if we want to trace it? Im not sure is some library that i run update the function
Does the table just have 3 rows?
Check the Dashboard in Database/Triggers with the public schema and see if you have a trigger on the orders table.
Are you running the query in the SQL with the Postgres role as seen here in image.
If not do you have RLS on this table?
Yup, the table orders only have 3 rows
I have not setup any user, it must be use postgres.
But, currently i test it again and it run normal.
How it happen?
