hpqtypes-extras-1.14.0.0 (2021-12-13)

• Add Support for ON CONFLICT to sqlInsertSelect.
• Remove upper bounds from library dependencies.
• Remove kRun* and kWhyNot functions.

hpqtypes-extras-1.13.1.0 (2021-11-26)

• Add support for including columns in indexes.

hpqtypes-extras-1.13.0.0 (2021-11-08)

• 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.

hpqtypes-extras-1.12.0.1 (2021-10-11)

• Add support for log-base-0.11.0.0

hpqtypes-extras-1.12.0.0 (2021-10-??)

• Use plain exceptions instead of DBExtraException

hpqtypes-extras-1.11.0.0 (2021-03-29)

• Support running with higher table versions in the database than in the code

hpqtypes-extras-1.10.4.0 (2021-02-04)

• Generate valid INSERT SELECT query with data modifying WITH clauses
• Add DerivingVia helpers for enums

hpqtypes-extras-1.10.3.0 (2020-11-16)

• Include LIMIT clause in UNION subqueries of the select

hpqtypes-extras-1.10.2.1 (2020-05-05)

• Add support for GHC 8.10

hpqtypes-extras-1.10.2.0 (2020-01-20)

• Add support for UNION clause
• Add support for GHC 8.8

hpqtypes-extras-1.10.1.0 (2020-01-09)

• Add support for ON CONFLICT clause

hpqtypes-extras-1.10.0.0 (2019-11-05)

• Implement UuidT Column Type (#28).
• Fix sqlValidateCheck and sqlValidateFK

hpqtypes-extras-1.9.0.1 (2019-06-04)

• Create composite types automatically only if database is empty (#24).

hpqtypes-extras-1.9.0.0 (2019-05-22)

• Extend checkDatabaseAllowUnknownTables to allow unknown composite types and rename it to checkDatabaseAllowUnknownObjects (#22).
• Remove the Default instance for ExtrasOptions; use defaultExtrasOptions instead (#23).

hpqtypes-extras-1.8.0.0 (2019-04-30)

• Make composite types subject to migration process (#21).
• Add a migration type for concurrent creation of an index (#21).

hpqtypes-extras-1.7.1.0 (2019-02-04)

• Fix an issue where unnecessary migrations were run sometimes (#18).

hpqtypes-extras-1.7.0.0 (2019-01-08)

• 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.

hpqtypes-extras-1.6.4.0 (2019-02-04)

• Fix an issue where unnecessary migrations were run sometimes (#19).

hpqtypes-extras-1.6.3.0 (2018-11-19)

• API addition: sqlWhereAnyE (#16).

hpqtypes-extras-1.6.2.0 (2018-07-11)

• Support hpqtypes-1.6.0.0.
• Drop support for GHC < 8.

hpqtypes-extras-1.6.1.0 (2018-03-18)

• Add support for GHC 8.4.
• Drop support for GHC 7.8.

hpqtypes-extras-1.6.0.0 (2018-01-25)

• Introduce checkPKPresence to enforce primary keys on all tables supplied to checkDatabase
• Introduce an options data type, ExtrasOptions

hpqtypes-extras-1.5.0.1 (2018-01-09)

• Changed getDBTableNames to only schemas explicitly in search path, rather than an exclusion list. Affects table version and unknown tables checks.

hpqtypes-extras-1.5.0.0 (2017-12-08)

• 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.

hpqtypes-extras-1.4.0.0 (2017-11-24)

• Introduced tsvector postgres type and indexing methods GIN and BTree

hpqtypes-extras-1.3.1.1 (2017-07-21)

• Now depends on ‘log-base’ instead of ‘log’.

hpqtypes-extras-1.3.1.0 (2017-07-20)

• Improved migration order sanity checking (#7).

hpqtypes-extras-1.3.0.0 (2017-05-17)

• Add drop table migrations.
• Add a test suite.
• Improve documentation.
• Add option to force commit after every migration.

hpqtypes-extras-1.2.4 (2016-07-28)

• Initial release.