SQL to enable pg_net in supabase guide incorrect

[selbyk]

Improve documentation

Link

https://supabase.com/docs/guides/database/extensions/pgnet

Describe the problem

Documentation is incorrect

The sql to enable pg_net extension in the doc is:

create schema if not exists net;
create extension pg_net with schema net;

but was getting error

{"Type":"ErrorResponse","Severity":"ERROR","SeverityUnlocalized":"ERROR","Code":"55000","Message":"schema net is not a member of extension \"pg_net\"","Detail":"An extension may only use CREATE ... IF NOT EXISTS to skip object creation if the conflicting object is one that it already owns.","Hint":"","Position":0,"InternalPosition":0,"InternalQuery":"","Where":"","SchemaName":"","TableName":"","ColumnName":"","DataTypeName":"","ConstraintName":"","File":"pg_depend.c","Line":274,"Routine":"checkMembershipInCurrentExtension","UnknownFields":null}

Describe the improvement

https://github.com/supabase/pg_net/blob/master/docs/installation.md had the sql I needed to enable the extension by migration:

create extension pg_net;

Additional context

Thanks @GaryAustin1

[selbyk]

Closed. Opened in correct repo: supabase/supabase#10986