diff options
author | Yorick Peterse <yorickpeterse@gmail.com> | 2016-06-14 13:17:41 +0300 |
---|---|---|
committer | Yorick Peterse <yorickpeterse@gmail.com> | 2016-06-14 13:19:38 +0300 |
commit | c6744b49497fca340c8ee5b9913f805ec8ea9be8 (patch) | |
tree | 0d299572c979e89ead69cef57dff7028037fdbe6 /db/migrate/20160416182152_convert_award_note_to_emoji_award.rb | |
parent | d032c6b0ff77a9a7568e1be8c728e252ddc1b11a (diff) |
Fixed locking syntax for PostgreSQL
Diffstat (limited to 'db/migrate/20160416182152_convert_award_note_to_emoji_award.rb')
-rw-r--r-- | db/migrate/20160416182152_convert_award_note_to_emoji_award.rb | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/db/migrate/20160416182152_convert_award_note_to_emoji_award.rb b/db/migrate/20160416182152_convert_award_note_to_emoji_award.rb index 6d57b796151..95ee03611d9 100644 --- a/db/migrate/20160416182152_convert_award_note_to_emoji_award.rb +++ b/db/migrate/20160416182152_convert_award_note_to_emoji_award.rb @@ -19,7 +19,7 @@ class ConvertAwardNoteToEmojiAward < ActiveRecord::Migration def migrate_postgresql connection.transaction do - execute 'LOCK notes IN EXCLUSIVE' + execute 'LOCK notes IN EXCLUSIVE MODE' execute "INSERT INTO award_emoji (awardable_type, awardable_id, user_id, name, created_at, updated_at) (SELECT noteable_type, noteable_id, author_id, note, created_at, updated_at FROM notes WHERE is_award = true)" execute "DELETE FROM notes WHERE is_award = true" remove_column :notes, :is_award, :boolean |