github xataio/pgroll v0.5.0

latest releases: v0.7.0, v0.6.0
8 months ago
  • ❌ Extend the alter_column operation to allow dropping NOT NULL constraints from columns [docs]
  • 💬 Add support for adding comments to tables and columns at creation time [docs]
  • 🔑 Correctly preserve column constraints when duplicating columns for backfilling [issue]
  • 🐛 Ensure that the drop_column operation works for tables and columns with reserved words as names
  • 🦺 Update the JSON schema for migration operations to more accurately reflect required and optional fields

Changelog

  • f1757f3 Add CI check for up-to-date type generation (#225)
  • d00d804 Add JSON schema tests (#263)
  • eed4e4e Add JSON schema validation tests for 'sql' operations (#266)
  • 70a7c8e Add CHECK constraints to pgroll's internal schema representation (#241)
  • 994a1aa Add UNIQUE constraints to pgroll's internal schema representation (#242)
  • f798ba5 Add a CI check for unreachable code using deadcode (#251)
  • 73c2016 Add a way to set postgres role when executing migrations (#226)
  • b9e7819 Add drop NOT NULL operation to remove NOT NULL from a column (#258)
  • 9d25159 Add fields to GROUP BY clauses in read_schema function (#255)
  • 025a38f Add missing comment to field (#229)
  • 61cc53a Add support for creating tables and columns with comments (#224)
  • dde27eb Add test: check column DEFAULTs preserved on set NOT NULL (#235)
  • 66ccf91 Add unique & FK constraints info to the schema (#218)
  • 83b5d76 Allow to disable version schemas (#233)
  • 4450862 Bump actions/checkout to v4 (#272)
  • 72cc155 Bump github.com/containerd/containerd from 1.7.3 to 1.7.11 (#217)
  • c5a3dbd Bump github.com/opencontainers/runc from 1.1.5 to 1.1.12 (#260)
  • 4b124b0 Change Complete method signature (#231)
  • 355ac20 Correctly quote table and column names in the drop column operation (#254)
  • 14e3d1b Ensure constraint existence as part of validation for the drop constraint operation (#252)
  • 7e65cda Fix inferred migrations format (#259)
  • c10dabf Fix pgroll migration definition (#216)
  • bb79eec Fix raw SQL migrations spec in schema.json (#264)
  • 7a38e1f Identify duplicated foreign key constraints by prefix (#245)
  • b2e93a9 Improve MustNotInsert test assertions (#243)
  • 7b5fafd Improve constraint assertions (#240)
  • 908485f Include key columns for an index in the internal schema representation (#248)
  • c95bc78 Parameterize schema in which migration tests run via PGROLL_TEST_SCHEMA env var (#276)
  • 68c5fbf Preserve CHECK constraints on duplication (#244)
  • 7c1167a Preserve NOT NULL attributes on column duplication (#246)
  • 9e9eeaf Preserve UNIQUE constraints on column duplication (#250)
  • ddb91d1 Preserve column properties on add CHECK constraint operation (#236)
  • 4928cf1 Preserve column properties on add FOREIGN KEY constraint operation (#238)
  • 7b7caa0 Preserve column properties on add UNIQUE constraint operation (#237)
  • 04de471 Preserve column properties on drop constraint operation (#253)
  • d803689 Preserve default on column duplication when changing column type (#234)
  • b81c42c Preserve foreign key constraints on columns duplicated for backfilling (#230)
  • fc7370f Preserve foreign key constraints when changing a column's type (#232)
  • 4bee7ac Record index uniqueness in pgroll's internal schema representation (#247)
  • 7fd8c7c Remove RAISE NOTICE statements (#256)
  • 82b7937 Remove unused function (#228)
  • 7404ddf Run go-jsonschema container with --rm (#267)
  • 889946b Run migration tests in a non-public schema as part of CI (#279)
  • 5686ddc Strengthen assertions for tests that check preservation of UNIQUE constraints (#277)
  • e906da7 Strip schema from index names in internal schema representation (#278)
  • a5cf473 Take go version from go mod version in buid workflow (#271)
  • d06a0af Update JSON schema to specify that not all Column fields are required (#265)
  • 5a6a83a Update schema.json to correctly describe the 'alter column' operation (#261)
  • 9586b44 Update state command to avoid returning nulls (#274)
  • 0cc62c1 docs/readme: broken code syntax (#270)

Don't miss a new pgroll release

NewReleases is sending notifications on new releases.