ERROR: extension "pg_net" has no installation script nor update path for version "0.7.3"

[digoal]

Bug report

• [ ] I confirm this is a bug with Supabase, not with my own application.
• [ ] I confirm I have searched the Docs, GitHub Discussions, and Discord.

Describe the bug

A clear and concise description of what the bug is.

To Reproduce

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

create extension pg_net;

Expected behavior

A clear and concise description of what you expected to happen.

Screenshots

If applicable, add screenshots to help explain your problem.

System information

• OS: [e.g. macOS, Windows]
• Browser (if applies) [e.g. chrome, safari]
• Version of supabase-js: [e.g. 6.0.2]
• Version of Node.js: [e.g. 10.10.0]

Additional context

# cd pg_net/sql
# cp -f -n ./pg_net.sql ./pg_net--0.7.3.sql /usr/share/postgresql/14/extension/

[steve-chavez]

@digoal Please share the steps you followed to run into this error.

Was it a make && make install? https://github.com/supabase/pg_net#configuring-your-deviceserver

[steve-chavez]

cd pg_net/sql cp -f -n ./pg_net.sql ./pg_net--0.7.3.sql /usr/share/postgresql/14/extension/

Ah, I think I get it. You're not using make to install the extension.

When you run make it will generate pg_net--0.7.3.sql, thus clear the error you're seeing. This is defined here:

https://github.com/supabase/pg_net/blob/master/Makefile#L15-L16

Please use make && make install otherwise we cannot ensure the correct installation.