© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•5mo ago•
23 replies
Grant

Supabase Error: ERROR: column "public" of relation "buckets" does not exist

We're seeing a strange error after upgrading our npm supabase package from v2.40.1 to v2.45.5 (for compliance reasons).

Our CI is broken and we're unable to proceed work.

We cannot run supabase locally.

Applying migration 20250320010804_add_file_hash_sync_local_remote.sql...
Applying migration 20250321022805_storage_bucket_creation_and_rls.sql...
Stopping containers...
ERROR: column "public" of relation "buckets" does not exist (SQLSTATE 42703)
At statement: 0                                                             
-- Create the migration-blobs bucket                                        
insert into storage.buckets                                                 
  (id, name, public, file_size_limit)                                       
             ^                                                              
Try rerunning the command with --debug to troubleshoot the error.
Applying migration 20250320010804_add_file_hash_sync_local_remote.sql...
Applying migration 20250321022805_storage_bucket_creation_and_rls.sql...
Stopping containers...
ERROR: column "public" of relation "buckets" does not exist (SQLSTATE 42703)
At statement: 0                                                             
-- Create the migration-blobs bucket                                        
insert into storage.buckets                                                 
  (id, name, public, file_size_limit)                                       
             ^                                                              
Try rerunning the command with --debug to troubleshoot the error.


We have previous db migrations such as 20250321022805_storage_bucket_creation_and_rls.sql:

-- Create the migration-blobs bucket
insert into storage.buckets
  (id, name, public, file_size_limit)
select *
from ( values ('migration-blobs', 'migration-blobs', false, 5368709120) ) as data(id, name, public, file_size_limit)
where not exists (select 1
                  from storage.buckets
                  where id = data.id);
-- Create the migration-blobs bucket
insert into storage.buckets
  (id, name, public, file_size_limit)
select *
from ( values ('migration-blobs', 'migration-blobs', false, 5368709120) ) as data(id, name, public, file_size_limit)
where not exists (select 1
                  from storage.buckets
                  where id = data.id);


What do we do? What version of supabase is the hosted version running so we can match that version locally?
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

relation \"public.undefined\" does not exist supabase table
SupabaseSSupabase / help-and-questions
3y ago
relation "public.users" does not exist
SupabaseSSupabase / help-and-questions
3y ago
relation 'public.table_name' does not exist
SupabaseSSupabase / help-and-questions
4y ago
42P01 relation public.profiles does not exist
SupabaseSSupabase / help-and-questions
4y ago