increase lock timeout option and safer drop column for composite indexes

What's Changed

Fixes 🐛

• Fix check used when adding non null constraint by @teckwan in #142
• BatchRecord: select primary keys instead of full records by @maximerety in #138

New Features 🎉

• Added new check to ensure composite indexes are dropped ahead of columns removal by @CharlotteFeather in #141
• Tt 23249 increment lock_timeout gradually to reduce failing migrations by @MouadHilali and @CharlesDelannoy in #140

New Contributors

• @maximerety made their first contribution in #137
• @teckwan made their first contribution in #142
• @CharlotteFeather made their first contribution in #141

Full Changelog: v3.0.1...v3.1.0

v3.0.1

What's Changed

Bugfix 🔨

• Fix args bug for create_table by @CharlesDelannoy in #134

Full Changelog: v3.0.0...v3.0.1

safe-pg-migration 3.0.0

What's Changed

Fixes 🐛

• DODO 1632 not idempotent add_column when type differ by @CharlesDelannoy in #123

New Features 🎉

• remove dependency to activerecord max 7.0 by @CharlesDelannoy in #130
  ==> Now we support 7.1 and above
• stop ruby 2 support by @CharlesDelannoy in #132

Full Changelog: v2.3.0...v3.0.0

v2.3.0

What's Changed

New Features 🎉

• Add add_check_constraint to the retryable actions by @CharlesDelannoy in #117
• DODO 1552 add_check_constraint to the sensitive logger by @CharlesDelannoy in #118
• bump new version (2.3.0) by @CharlesDelannoy in #119

New Contributors

• @CharlesDelannoy made their first contribution in #117

Full Changelog: v2.2.1...v2.3.0

v2.2.1

What's Changed

Fixes 🐛

• Railtie: next unless of break by @ThHareau in #111
• Detect and reuse already existing constraint by @ThHareau in #112

Full Changelog: v2.2.0...v2.2.1

v2.2.0

What's Changed

New Features 🎉

• Make lock_timeout configurable by @ThHareau in #102
• Bugfix: UselessStatementLogger now warns when disable_ddl_transaction is called by @ThHareau in #104
• Add sensitive_logger by @ThHareau in #101
• Introduce default_value_backfill_threshold: config to avoid unwanted long migration when adding a column with :update_in_batches by @ThHareau in #105
• drop_table: Remove foreign keys before removing a column by @ThHareau in #107
• Set statement timeout by default by @ThHareau in #106

Full Changelog: v2.1.0...v2.2.0

v2.1.0

What's Changed

New Features 🎉

• Adding drop_table to the list of retriable statements by @MouadHilali in #93
• Add safe add_check_constraint by @ThHareau in #95
• safe change_column_null by @ThHareau in #97
• Add small margin to lock timeout, otherwise it is hidden by statement timeouts by @ThHareau in #99
• Implement default_value_backfill algorithm in add_column by @ThHareau in #98

New Contributors

• @MouadHilali made their first contribution in #93

Full Changelog: v2.0.0...v2.1.0

v2.0.0

What's Changed

Breaking

• Drop Ruby 2.5, 2.6 and ActiveRecord < 6, add ruby 3.2 and AR 7.0 by @ThHareau in #80
• Remove support for PG 9 and 10 as they are EOL by @ThHareau in #82

Features:

• Add remove_foreign_key idempotent by @ThHareau in #79
• Add safe_pg_migrations_verbose by @ThHareau in #86
• Add logs when add_index is taking too long by @ThHareau in #91

Fixes:

• Fix Add index for ruby 3.0 by @MaximeRDY in #78
• Fix deprecated ActiveRecord::Base.verbose_query_logs by @ThHareau in #87

New Contributors

• @MaximeRDY made their first contribution in #78
• @tanguy-platsec made their first contribution in #81

Full Changelog: v1.4.2...v2.0.0

v1.4.2

What's Changed

Fixes:

• Fix ruby2_keyword warning by @ThHareau in #75

Full Changelog: v1.4.1...v1.4.2