Changelog for hpqtypes-extras-1.9.0.1
- Create composite types automatically only if database is empty.
- Extend
checkDatabaseAllowUnknownTables
to allow unknown composite
types and rename it to checkDatabaseAllowUnknownObjects
(#22).
- Remove the
Default
instance for ExtrasOptions
; use
defaultExtrasOptions
instead
(#23).
- Make composite types subject to migration process
(#21).
- Add a migration type for concurrent creation of an index
(#21).
- Fix an issue where unnecessary migrations were run sometimes
(#18).
- 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.
- Fix an issue where unnecessary migrations were run sometimes
(#19).
- 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.