Changelog for hpqtypes-extras-1.7.0.0
- Added support for no-downtime migrations
(#17):
sqlCreateIndex is deprecated. Use either
sqlCreateIndexSequentially or sqlCreateIndexConcurrently
(no-downtime migration variant) instead.
sqlAddFK is deprecated. Use either sqlAddValidFK or
sqlAddNotValidFK (no-downtime migration variant) instead.
- API addition:
sqlValidateFK, for validating a foreign key
previously added with sqlAddNotValidFK.
sqlAddCheck is deprecated. Use either sqlAddValidCheck or
sqlAddNotValidCheck (no-downtime migration variant) instead.
- API addition:
sqlValidateCheck, for validating a check
previously added with sqlAddNotValidCheck.
- API addition:
sqlAddPKUsing, converts a unique index to a
primary key.
- New
Table field: tblAcceptedDbVersions.
ValidationResult is now an abstract type.
ValidationResult now supports info-level messages in addition to errors.
- API addition:
sqlWhereAnyE
(#16).
- Support hpqtypes-1.6.0.0.
- Drop support for GHC < 8.
- Add support for GHC 8.4.
- Drop support for GHC 7.8.
- Introduce
checkPKPresence to enforce primary keys on all tables supplied to checkDatabase
- Introduce an options data type,
ExtrasOptions
- Changed
getDBTableNames to only schemas explicitly in search path, rather
than an exclusion list. Affects table version and unknown tables checks.
- Changed internal representation of PrimaryKey to NubList (#11)
This will break existing PKs set on multiple columns unless they are
alphabetically sorted in the defining list.
- Introduced tsvector postgres type and indexing methods GIN and BTree
- Now depends on 'log-base' instead of 'log'.
- Improved migration order sanity checking (#7).
- Add drop table migrations.
- Add a test suite.
- Improve documentation.
- Add option to force commit after every migration.