aboutsummaryrefslogtreecommitdiffstats
path: root/guides/source/command_line.md
diff options
context:
space:
mode:
authorYasuo Honda <yasuo.honda@gmail.com>2018-05-07 09:22:23 +0000
committerYasuo Honda <yasuo.honda@gmail.com>2018-05-22 02:08:08 +0000
commit45881b0a64b4039e3b0d27e2c4d959dc2d744b9d (patch)
tree65e402e81ee4ce49cabcaf02f4c30540eb109600 /guides/source/command_line.md
parent054893d574f9c5eebc13d3749680f3a264e4b57d (diff)
downloadrails-45881b0a64b4039e3b0d27e2c4d959dc2d744b9d.tar.gz
rails-45881b0a64b4039e3b0d27e2c4d959dc2d744b9d.tar.bz2
rails-45881b0a64b4039e3b0d27e2c4d959dc2d744b9d.zip
Disable foreign keys during `alter_table` for sqlite3 adapter
Unlike other databases, changing SQLite3 table definitions need to create a temporary table. While changing table operations, the original table needs dropped which caused `SQLite3::ConstraintException: FOREIGN KEY constraint failed` if the table is referenced by foreign keys. This pull request disables foreign keys by `disable_referential_integrity`. Also `disable_referential_integrity` method needs to execute `defer_foreign_keys = ON` to defer re-enabling foreign keys until the transaction is committed. https://www.sqlite.org/pragma.html#pragma_defer_foreign_keys Fixes #31988 - This `defer_foreign_keys = ON` has been supported since SQLite 3.8.0 https://www.sqlite.org/releaselog/3_8_0.html and Rails 6 requires SQLite 3.8 #32923 now - <Models>.reset_column_information added to address `ActiveModel::UnknownAttributeError` ``` Error: ActiveRecord::Migration::ForeignKeyChangeColumnTest#test_change_column_of_parent_table: ActiveModel::UnknownAttributeError: unknown attribute 'name' for ActiveRecord::Migration::ForeignKeyChangeColumnTest::Post. ```
Diffstat (limited to 'guides/source/command_line.md')
0 files changed, 0 insertions, 0 deletions