Skip to content

Schema supabase_functions does not exist (local development) #925

Description

@mousindev

Bug report

Describe the bug

When trying to create a Database Webhook function in my local Supabase Studio, I get the following error:
Failed to create hook: schema "supabase_functions" does not exist

To Reproduce

Steps to reproduce the behavior, please provide code snippets or a repository:

  1. Start local supabase dev environment supabase start (while Docker is running)
  2. Open the local Supabase Studio (http://localhost:54323/project/default)
  3. On the left menu, go to Database
  4. Select Webhooks, enable them in Alpha and create a test webhook
  5. See error Failed to create hook: schema "supabase_functions" does not exist

Expected behavior

The Database Webhook should have been created correctly

Screenshots

image

System information

  • OS: Windows 10
  • Browser (if applies) Chrome
  • Version of Supabase CLI: 1.40.1 (latest available in Scoop as of today)

Additional points

  1. When doing it on the cloud instance, the Database Webhook is created correctly. If I then go to Table Editor => Schema supabase_functions -> Table hooks I see it empty. Is this correct? From the error above I assumed created Webhooks would be stored there. I see the Webhook in Database => Webhooks though.
  2. Are Webhooks captured as part of migrations and added to the sql file when a new migration is created?

Thanks!

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions