PG::SyntaxError: ERROR: syntax error at or near "USING"

Question

I'm having trouble migrating my table with Rails. When I run rake db:migrate I get this error.

Error

PG::SyntaxError: ERROR:  syntax error at or near "USING"
LINE 1: ALTER TABLE "assignments" ADD "frequency" integer USING CAST...

Migration

class AddBackFrequeny < ActiveRecord::Migration[5.0]
  def change
    add_column :assignments, :frequency, 'integer USING CAST(frequency AS integer)'
  end
end

I just changed my database to postgresql. maybe somethings there?

Evan Carroll · Accepted Answer · 2017-04-09 16:46:29Z

1

USING is only valid when you alter the DATA TYPE, not when you merely add a column. From \h ALTER

ALTER [ COLUMN ] column_name [ SET DATA ] TYPE data_type [ COLLATE collation ] [ USING expression ]
ADD [ COLUMN ] [ IF NOT EXISTS ] column_name data_type [ COLLATE collation ] [ column_constraint [ ... ] ]

answered Apr 9, 2017 at 16:46

Evan Carroll

1

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

Collectives™ on Stack Overflow

PG::SyntaxError: ERROR: syntax error at or near "USING"

Error

Migration

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Error

Migration

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related