Unable to run dbdev extension using the Getting Started script
I am using the script from the Installation page:
When I reset my DB (
pnpx supabase db reset --linked), I get the following error:
❯ pnpx supabase db reset --linked
WARN: no SMS provider is enabled. Disabling phone login
Initialising cli_login_postgres role...
Do you want to reset the remote database? [y/N] y
Resetting remote database...
...
NOTICE (42P06): schema "supabase_migrations" already exists, skipping
NOTICE (42P07): relation "schema_migrations" already exists, skipping
NOTICE (42701): column "statements" of relation "schema_migrations" already exists, skipping
NOTICE (42701): column "name" of relation "schema_migrations" already exists, skipping
Applying migration 20241031000000_dbdev.sql...
NOTICE (00000): role "postgres" is already a member of role "pgtle_admin"
NOTICE (00000): extension "supabase-dbdev" does not exist, skipping
WARNING (01000): Extension supabase-dbdev has an anomaly; control function exists, but no sql commands function exists
ERROR: type "http_header" does not exist (SQLSTATE 42704)
At statement: 4
select pgtle.install_extension(
'supabase-dbdev',
resp.contents->>'version',
'PostgreSQL package manager',
resp.contents->>'sql'
)
from http(
(
'GET',
'https://api.database.dev/rest/v1/' || 'package_versions?select=sql,version' || '&package_name=eq.supabase-dbdev' || '&order=version.desc' || '&limit=1',
array [
('apiKey', 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZSIsInJlZiI6InhtdXB0cHBsZnZpaWZyYndtbXR2Iiwicm9sZSI6ImFub24iLCJpYXQiOjE2ODAxMDczNzIsImV4cCI6MTk5NTY4MzM3Mn0.z2CN0mvO2No8wSi46Gw59DFGCTJrzM0AQKsu_5k134s')::http_header
❯ pnpx supabase db reset --linked
WARN: no SMS provider is enabled. Disabling phone login
Initialising cli_login_postgres role...
Do you want to reset the remote database? [y/N] y
Resetting remote database...
...
NOTICE (42P06): schema "supabase_migrations" already exists, skipping
NOTICE (42P07): relation "schema_migrations" already exists, skipping
NOTICE (42701): column "statements" of relation "schema_migrations" already exists, skipping
NOTICE (42701): column "name" of relation "schema_migrations" already exists, skipping
Applying migration 20241031000000_dbdev.sql...
NOTICE (00000): role "postgres" is already a member of role "pgtle_admin"
NOTICE (00000): extension "supabase-dbdev" does not exist, skipping
WARNING (01000): Extension supabase-dbdev has an anomaly; control function exists, but no sql commands function exists
ERROR: type "http_header" does not exist (SQLSTATE 42704)
At statement: 4
select pgtle.install_extension(
'supabase-dbdev',
resp.contents->>'version',
'PostgreSQL package manager',
resp.contents->>'sql'
)
from http(
(
'GET',
'https://api.database.dev/rest/v1/' || 'package_versions?select=sql,version' || '&package_name=eq.supabase-dbdev' || '&order=version.desc' || '&limit=1',
array [
('apiKey', 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZSIsInJlZiI6InhtdXB0cHBsZnZpaWZyYndtbXR2Iiwicm9sZSI6ImFub24iLCJpYXQiOjE2ODAxMDczNzIsImV4cCI6MTk5NTY4MzM3Mn0.z2CN0mvO2No8wSi46Gw59DFGCTJrzM0AQKsu_5k134s')::http_header
0 Replies