PG::SyntaxError: ERROR: syntax error at or near "USING" LINE 1: SELECT 'integer[] USING ARRAY ... +rails 6.1

Question

I am attempting to db:migrate:reset and encountered this error:

rails aborted!
StandardError: An error has occurred, this and all later migrations canceled:

PG::SyntaxError: ERROR:  syntax error at or near "USING"
LINE 1: SELECT 'integer[] USING ARRAY[pdf_page_number]::INTEGER...
              ^
CONTEXT:  invalid type name "integer[] USING ARRAY[pdf_page_number]::INTEGER[][]"

The migration file causing this error:

class ChangeCartItemsPageNumbersToArray < ActiveRecord::Migration[5.2]
  def up
    change_column :cart_items, :pdf_page_number, 'integer[] USING ARRAY[pdf_page_number]::INTEGER[]', array: true, null: false, default: []
  end
end

Thanks!

woa · Accepted Answer · 2021-03-18 01:33:02Z

1

This fixed it:

change_column :cart_items, :pdf_page_number, :integer, using: 'ARRAY[pdf_page_number]::INTEGER[]', array: true, null: false, default: []

This question/answer very helpful

answered Mar 18, 2021 at 1:33

woa

233 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PG::SyntaxError: ERROR: syntax error at or near "USING" LINE 1: SELECT 'integer[] USING ARRAY ... +rails 6.1

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related