Rails will not run this PostgreSQL migration, why?

Question

I have this as a migration :

def up
  connection.execute(%q{
    alter table enterprise_members
    alter column sso_id
    type string using cast(sso_id as string)
  })
end

Where I am simply trying to convert an integer into a string. But when run, it returns :

PG::UndefinedObject: ERROR:  type "string" does not exist
: 
        alter table enterprise_members
        alter column sso_id
        type string using cast(sso_id as string)

Is it because I'm trying to cast it? How do I fix this?

Varchar, char, text are database typesm "string" is not. Character data types can be found on the manual — Vitor Tyburski
– Vitor Tyburski, Commented May 16, 2014 at 12:54

Kostas Rousis · Accepted Answer · 2014-05-16 12:55:36Z

4

You can call string when you are using Rails but if you choose to go the manual way, as you did in your snippet, you have to stick in your DBMS' datatypes

Which brings up another point: try to be DB-agnostic when you can!

answered May 16, 2014 at 12:55

Kostas Rousis

6,1361 gold badge35 silver badges39 bronze badges

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

1 Comment

Trip Over a year ago

Evidently I couldn't cast the other way and I had to write it manual.

Collectives™ on Stack Overflow

Rails will not run this PostgreSQL migration, why?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related