SupabaseS
Supabase•4y ago
Julian IncrEdelman

CLI Start & Stop fails with graphql.get_built_schema_version() does not exist

I:
  • had a local DB
  • added some tables (I did enable the "set updated_at" trigger)
  • I wanted to enable a plugin (the psql audit plugin)
  • I couldn't find how to restart the local db so did "supabase stop & start"
That failed (I think the start), and now whenever I start, I get the following:

2022/11/17 15:50:21 PG Recv: {"Type":"ErrorResponse","Severity":"ERROR","SeverityUnlocalized":"ERROR","Code":"42883","Message":"function graphql.get_built_schema_version() does not exist","Detail":"","Hint":"","Position":0,"InternalPosition":0,"InternalQuery":"","Where":"","SchemaName":"","TableName":"","ColumnName":"","DataTypeName":"","ConstraintName":"","File":"parse_func.c","Line":2444,"Routine":"LookupFuncWithArgs","UnknownFields":null}
2022/11/17 15:50:21 PG Recv: {"Type":"ReadyForQuery","TxStatus":"I"}
2022/11/17 15:50:21 PG Send: {"Type":"Terminate"}
Error: ERROR: function graphql.get_built_schema_version() does not exist (SQLSTATE 42883)
At statement 107:


--
-- Name: FUNCTION "get_built_schema_version"(); Type: ACL; Schema: graphql; Owner: supabase_admin
--

GRANT ALL ON FUNCTION "graphql"."get_built_schema_version"() TO "postgres";
Was this page helpful?