3
Supabase migrations don't include table/column comments
Source: supabase/supabase#19478 · opened by @dawnmist
Bug report Describe the bug Comments added to tables or columns are not included in the diff when a migration is created from that database. This results in being unable to document tables, as any comments in the dev db will be lost when it is next reset, and none of the dev db comments can be propagated to staging/prod because they're not part of the migration files. To Reproduce Steps to reproduce the behavior, please provide code snippets or a repository: 1. Use the example countries SQL to create a new countries table with comment descriptions for the table and each column in your local dev db. (Accessible from a hosted supabase project => SQL editor => Welcome => Quickstart => Countries) 2. Run supabase db diff -f add_countries to generate a migration for that countries table. Expected behavior Expect the generated migration to include the commands to create the table, any indexes that were defined, and all comments, as per: Actual be…
No pledges yet. Be the first to back this.
Comments
Similar requests
Support for versioned subfolders in migrations
2 votes · 0 comments
Allow Customization of /migrations Directory in config.toml for Supabase Migrations and Shadow Database
7 votes · 0 comments
Supabase MCP Server for local development use
2 votes · 0 comments
Restrict database schema changes in web UI
13 votes · 0 comments
Rollback ("down") Migrations
171 votes · 0 comments
No comments yet.