v0.14.0

⚡ Highlights

✅ Validate migrations before execution with the new pgroll validate command
⚙️ Auto update migration files with the new pgroll update command
📁 Get the connection string for the most recent version schema with the newpgroll latest url command
📛 Specify version schema names with the version_schema field or run without them with the --use-version-schema flag

Read the release blog post for more details: https://pgroll.com/blog/pgroll-0-14-0-update

Changelog

• 63a8f4b Add --yes flag to pgroll baseline (#865)
• 050e2ea Add VersionSchema field to operation integration tests (#886)
• a90b587 Add pgroll latest url command (#927)
• 1fb32c8 Add a global --use-version-schema flag to the pgroll CLI (#919)
• a7c4bb5 Add coverage job again (#868)
• 6c32984 Add coverage report to pull requests (#864)
• 5cbaa73 Add documentation for the pgroll latest url command (#928)
• 063a244 Add more details to update subcommand page (#877)
• fe34c2c Add new DBAction to add columns to existing tables (#894)
• 934a20e Add new DBAction to rename tables (#893)
• f672053 Add new DBAction: RenameDuplicatedColumnAction (#883)
• b533a14 Add new DBActions for setting and dropping default values (#892)
• c3fddb3 Add new subcommand to update migrations that contain breaking changes (#855)
• f8bf96f Add new subcommand to validate migration files (#856)
• ebd41aa Add tests for SchemaAfterMigration method (#926)
• 5b3c948 Add trigger configuration to backfill.Task (#931)
• 1dd00ff Allow migration files to specify a versionSchema field (#884)
• 899645a Always remove version schema on rollback and complete (#920)
• 68b779b Bump golangci-lint to v2 (#904)
• 531a919 Bump github.com/go-viper/mapstructure/v2 from 2.2.1 to 2.3.0 (#941)
• 25fe03e Bump github.com/pterm/pterm from 0.12.80 to 0.12.81 (#870)
• 21589af Bump github.com/santhosh-tekuri/jsonschema/v6 from 6.0.1 to 6.0.2 (#857)
• f028dc3 Bump golang.org/x/tools from 0.33.0 to 0.34.0 (#871)
• 914582b Bump sigs.k8s.io/yaml from 1.4.0 to 1.5.0 (#942)
• 92bb10a Combine the return values of Start into a single data class (#945)
• aac8b31 Comment out coverage check, so we get a baseline (#867)
• 542166f Construct version schema name in Roll.StartDDLOperations without DB lookup (#912)
• 07d8d08 Ensure lex ordering of inferred migration names with respect to pgroll migrations (#899)
• 146d740 Ignore all DDL executed by pgroll (#890)
• 192f4eb Keep pgroll state schema in sync with pgroll binary version (#876)
• 589bc33 Make pgroll latest schema ignore migrations for which no version schema exists (#916)
• 31dd8d1 Move Status method to roll package (#921)
• b6c7a94 Move TriggerConfig to backfill package (#923)
• 22d7cc2 New DBAction for adding unique constraints using indices (#897)
• 535abb3 New DBAction for creating index concurrently (#939)
• e01a51f New DBAction for setting replica identity (#938)
• d2a1212 New DBAction to create primary key constraint from index (#901)
• 711b4d4 New DBAction to run raw SQL statements (#898)
• 44e4e00 New DBAction: SetNotNullAction (#878)
• 0ac2095 Remove Ensure JSON examples are formatted CI step (#873)
• a75c3f6 Remove State.LastSchema method (#909)
• e7786f5 Remove WithNoVersionSchemaForRawSQL opton (#903)
• 2150959 Remove examples-schema-validation CI build step (#874)
• 1fe1af8 Remove redundant check from MissingMigrations method (#911)
• 7f44302 Remove redundant check from UnappliedMigrations method (#869)
• 716f47f Remove redundant parameter from previous_migration function (#914)
• 6dfeb32 Remove unnecessary param from Start function (#934)
• 3532502 Rename WithDisableViewsManagement roll option (#917)
• c3c73e4 Rename pgroll.internal GUC to pgroll.no_inferred_migrations (#932)
• d7f2f61 Return DBActions from Complete (#902)
• 12dd5a2 Return DBActions from Rollback (#929)
• b117582 Return backfill.Task from Start phase operations (#924)
• 470b5ef Return list of DBAction from Start (#944)
• d8ce04e Revert "Bump github.com/pterm/pterm from 0.12.80 to 0.12.81 (#870)" (#875)
• 2293fdd Set default values for columns in new schema version views (#860)
• c1b0f90 Simplify previous_migration function (#922)
• 7b932e9 Split pgroll latest (#861)
• be1a7cf Support altering primary key columns that are not included in FK constraints (#930)
• bc40891 Turn Duplicator into a DBAction (#937)
• 4971378 Update pgroll latest to take account of migration version_schema (#896)
• 1e4ed72 Update docs for new versionSchema field (#887)
• 6218ca4 Update docs with backfill-batch-delay and backfill-batch-size options (#881)
• c74a242 Update error type returned when Roll.LatestVersionRemote finds no version schema (#918)
• 6f73c9e Use DropIndexAction when rolling back index creation (#891)
• 9535bc2 Use DropFunctionAction in remaning operations (#880)
• 803868a Use jsonb_strip_nulls in read_schema function (#925)
• fcda88a Use existing dbactions in op_alter_column (#879)