Unable to Drop Trigger to Net Schema
Hey all, for some reason we have a trigger on the net schema that is writing data into supabase_function.hooks, and is overloading our database (200+MB of writes that are useless), but I am unable to drop it since it says this is read only.
2 Replies
Did you create the trigger/trigger function? what is the trigger/trigger function called if it's not one you created yourself? do you know if there are any implications it can cause if you were to be able to remove it? What makes you think the writes are useless and serve no purpose?
Yes, a teammate created the trigger. I believe this was a test function that was accidentally implemented. We do not query that table in our code, and the request here is to a website that is not real.
Here is the trigger definition
CREATE TRIGGER linkedin_scrape_snapshot AFTER INSERT ON net._http_response FOR EACH ROW EXECUTE FUNCTION supabase_functions.http_request('http://scraper.com/scraper', 'POST', '{"Content-type":"application/json"}', '{}', '5000')
I am not sure how this trigger was created in the first place either
Managed to fix it by deleting and reinstaling the extension