Issue

After adding a Supabase Webhook listening to the public.bids table in manifund-dev, submitting a bid now causes permission denied for schema net and the bid row does not get created.

• Removing the webhook fixes this
• This only occurs on manifund-dev Supabase, not manifund (prod).

Debugging

Theory 1: Doesn’t seem like role postgres has USAGE granted on schema net.

from manifund-dev:

manifund:

• But running GRANT USAGE ON SCHEMA net TO postgres; didn’t seem to work:

  

  Questions

  • Does SQL commands in the editor run with superuser permissions?
  • Why does inserting a new row fail? My understanding is that Supabase Webhooks should run after row insertion, instead of blocking new rows