Altering character limit on Heroku PostGRES doesn't change column in database

Question

In my Heroku postgres db, I had a column of type "string" with a limit of "50" characters.

I just made a migration that changed the limit to 80 characters.

class ChangeTagLineLimit < ActiveRecord::Migration
  def up
    change_column :blocks, :tag_line, :string, :limit => 80
  end
  def down
    change_column :blocks, :tag_line, :string, :limit => 50
  end
end

However when I try to save a record, I get this error:

PG::StringDataRightTruncation: ERROR: value too long for type character varying(50)

It sounds like PostGRES hasn't changed the size of the varchar column. How do I fix this?

tokoph · Accepted Answer · 2015-02-27 22:54:04Z

1

That migration should work. The error is probably related to another table that didn't get migrated yet.

answered Feb 27, 2015 at 22:54

tokoph

1187 bronze badges

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

Collectives™ on Stack Overflow

Altering character limit on Heroku PostGRES doesn't change column in database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related