Skip to content

Latest commit

 

History

History
417 lines (231 loc) · 12 KB

CHANGELOG.md

File metadata and controls

417 lines (231 loc) · 12 KB

Change Log

3.2.0

Added

  • Add support for opclass option in createIndex #259
  • Ability to specify extension schema #260

3.1.2

Fixed

  • Using dollar-quoted strings in comments #255

3.1.1

Fixed

  • Fixing optional options in create and drop statements #250

3.1.0

Added

  • Handling SQL files #246

3.0.0

3.0.0-rc5

Fixed

  • Fix comment not being optional #244
  • Fix behavior when singleTransaction is not set #245

3.0.0-rc4

Changed

  • Implement failsafe locking #239
  • Updated docs about locking #240

3.0.0-rc3

Added

  • Add log option to runner.js #238
  • Structuring docs #237
  • Prettier formatting #236
  • Displaying function name on infer failure #235
  • Materialized views handling #234
  • Handling Views #233
  • Cockroach test #231
  • Prettier #230

3.0.0-rc2

Fixed

  • Fixing setting comments on columns #228

2.26.3

Fixed

  • Fixing setting comments on columns #228

3.0.0-rc

Breaking changes

  • Single transaction as default #205
  • Versioning type shorthands #190 (type shorthands were moved from global config to migrations scripts)
  • Using camel case in API #189
  • Removed pg-migrate script (use node-pg-migrate)

Added

  • Running test migrations on CircleCI #221

2.26.2

Fixed

  • Fix runner for zero migrations #224

2.26.1

Fixed

  • Fixing altering role #222
  • Fixes from 3.0 #223

2.26.0

Added

  • Support for policies #219

2.25.1

Fixed

  • Role inherit fix #218

2.25.0

Fixed

  • (No)Transaction handling #213
  • Parens around INHERITS clause #214

Added

2.24.1

Fixed

  • Fix auto create schema #206

2.24.0

Added

  • Add --single-transaction option #204

2.23.1

Fixed

  • Correct handling of multiline constraints #202

2.23.0

Changed

  • Updating deps, removing vulnerablity status for peer and optional dependencies #199
  • Removing regex #198
  • Adding ability to specify database name with 'database' option #197

2.22.2

Fixed

  • Role encrypted default #196
  • Running queries in order #195

2.22.1

Fixed

  • Passing props #194

2.22.0

Added

  • Auto create configured schemas if they don't exist #192
  • Add ifNotExists option to create extension #188
  • Programmatic API docs #187

2.21.0

Added

  • Table and column comments #183

2.19.0

Added

  • migration-file-language can be set in config file #180
  • Treat number argument to up/down migration as timestamp #179

2.18.1

Fixed

  • Fixing addConstraint method with object expression #176

2.18.0

Added

  • Add no lock option #171
  • Updated docs #174

Changed

  • Remove old version number from index.d.ts #173
  • Remove default match in column reference #172
  • Refactor code to use camel casing #167

2.17.0

Added

  • Added typescript migration template #165
  • Updated type definitions to accept db client config #166

2.16.2

Fixed

  • Deleted duplicate declaration #164

2.16.1

Changed

  • Updated dependencies #158

Fixed

  • Typescript definition fixes #162

2.16.0

Added

  • Uniting drop statements #154
  • Handling domains #155
  • Operator operations #156
  • Sequences operations #157

2.15.0

Fixed

  • Handle rejections in migration actions #148

Added

2.14.0

Added

  • Deferrable column constraints #139
  • Possibility to use function in multi-column index #140

Changed

  • Changed all references from pg-migrate to node-pg-migrate #141

    !!! Breaking change from version 3 !!! (now with warning)

2.13.2

Fixed

  • Cannot use embedded value in config #137
  • add space before USING keyword #138

2.13.1

Fixed

  • addTypeValue's after option is using BEFORE instead of AFTER #133

2.13.0

Added

  • Ability to specify files to ignore in migrations directory #131

2.12.0

Fixed

  • Dollar quoted string constants #127
  • Table unique constraint can be array of arrays #126

Changed

  • If user disables migration, return Error instead of string #125
  • Circle CI integration #124
  • Moved to Salsita organization #122

2.11.1

Fixed

  • Fixed SQL for dropping multiple columns #120

2.11.0

Added

  • Schemas operations #119

2.10.1

Fixed

  • Fixed invalid SQL for table level foreign key #118

2.10.0

Added

  • Ability to specify constraints on table level #114

2.9.0

Added

  • Alter type functions #111
  • redo command #112

2.8.2

Fixed

  • Fix automatic reversal of addColumns #110

2.8.1

Fixed

  • Fixing referencing column #107

Changed

  • Formatting changes, added licence #108

2.8.0

Added

  • Trigger operations #104

2.7.1

Fixed

  • Support object with schema and table name in more places #105

2.7.0

Added

  • Function operations #103

2.6.0

Added

  • Support for pg >=4.3.0 <8.0.0
  • Interpret only files as migrations in migration directory #101

2.5.0

Added

  • USING clause in alter column #99
  • Role operations #100

2.4.0

Changed

  • Do not check file extension of migration file #93

2.3.0

Added

  • JSON config and type shorthands see #91

2.2.1

Fixed

  • Syntax error in node 4

2.2.0

Added

  • Better error logging #86
  • Locking migrations #88
  • Updated docs #89

2.1.1

Fixed

  • Down migration when down method is inferred #84

2.1.0

Added

  • Enable string functions and arrays as default column values #82

2.0.0

Rewritten using es6 (transpiled via babel) and Promises.

Breaking Changes

  • supports only node >= 4
  • check-order flag now defaults to true (to switch it off supply --no-check-order on command line)
  • dotenv package is optionalDependency
  • s option is now alias for schema which sets schema for migrations SQL, if you only need to change schema of migrations table use --migrations-schema

Added

  • config package as optionalDependency
  • Migration can return Promise