Rails Migrations: tried to change the type of column from string to integer

by

I quote the manual about ALTER TABLE:

A USING clause must be provided if there is no implicit or assignment
cast from old to new type.

What you need is:

ALTER TABLE listings ALTER longitude TYPE integer USING longitude::int;
ALTER TABLE listings ALTER latitude  TYPE integer USING latitude::int;

Or shorter and faster (for big tables) in one command:

ALTER TABLE listings
  ALTER longitude TYPE integer USING longitude::int
, ALTER latitude  TYPE integer USING latitude::int;

This works with or without data as long as all entries are valid as integer.
If the column has a DEFAULT, you may have to drop that (before the above) and recreate (after the above) for the new type.

Here is a blog article on how to do this with ActiveRecord.
Or go with @mu’s advice in the comment. He knows his Ruby. I only know well about the PostgreSQL part.

More Related Contents:

  1. PG::ConnectionBad – could not connect to server: Connection refused
  2. PG::Error: SELECT DISTINCT, ORDER BY expressions must appear in select list
  3. How to handle Ruby on Rails error: “Please install the postgresql adapter: `gem install activerecord-postgresql-adapter'”
  4. Can I write PostgreSQL functions on Ruby on Rails?
  5. Rails: PG::UndefinedTable: ERROR: relation “…” does not exist
  6. Store the day of the week and time?
  7. Adding foreign key to a rails model
  8. Is the server running on host “localhost” (::1) and accepting TCP/IP connections on port 5432?
  9. Format a string containing Phone numbers
  10. How to understand nil vs. empty vs. blank in Ruby
  11. Rails 4: List of available datatypes
  12. How to create a deep copy of an object in Ruby?
  13. Rails: Access to current_user from within a model in Ruby on Rails
  14. Is there a clean way to avoid calling a method on nil in a nested params hash? [duplicate]
  15. Ruby 2.4 and Rails 4 stack level too deep (SystemStackError)
  16. Custom authentication strategy for devise
  17. Using Process.spawn as a replacement for Process.fork
  18. Rails update_attributes without save?
  19. how to solve “ruby installation is missing psych” error?
  20. Detect MIME type of uploaded file in Ruby
  21. Pass a variable into a partial, rails 3?
  22. Creating a PostgreSQL sequence to a field (which is not the ID of the record)
  23. Uniq by object attribute in Ruby
  24. What does do in rails erb?
  25. PGError: ERROR: aggregates not allowed in WHERE clause on a AR query of an object and its has_many objects
  26. How to URL encode a string in Ruby
  27. Rails: FATAL – Peer authentication failed for user (PG::Error)
  28. What is the difference between Gemfile and Gemfile.lock in Ruby on Rails
  29. Parametrized get request in Ruby?
  30. Rails attachments inline are not shown correctly in gmail

Leave a Comment