- Add support for
sqlResult
in sqlDelete
.
- Add a migration type for modifying columns.
- Trigger functions are now part of triggers and have their names generated.
- Add support for GHC 9.2.
- Drop support for GHC < 8.8.
- Add support for triggers and trigger functions.
- Allow to specify the operator class of an index column.
- Support unmanaged local indexes whose names start with "local_".
- Add support for ON CONFLICT to sqlInsertSelect.
- Remove upper bounds from library dependencies.
- Remove kRun* and kWhyNot functions.
- Add support for including columns in indexes.
- Add support for handling lock_timeout during migrations.
- Improvements for making no downtime migrations easier to write.
- Commiting after each migration was made non-optional.
- Add support for log-base-0.11.0.0
- Use plain exceptions instead of DBExtraException
- Support running with higher table versions in the database than in the code
- Generate valid INSERT SELECT query with data modifying WITH clauses
- Add DerivingVia helpers for enums
- Include LIMIT clause in UNION subqueries of the select
- Add support for UNION clause
- Add support for GHC 8.8
- Add support for ON CONFLICT clause
- Implement
UuidT
Column Type (#28).
- Fix sqlValidateCheck and sqlValidateFK
- Create composite types automatically only if database is empty
(#24).
- 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.