Rails - How to add a BLOB column using ActiveRecord?

Question

I need to create a BLOB column to store some text content.

I have read somewhere that I need to do the following:

class AddVersionCommentToMetaData < ActiveRecord::Migration
  def self.up
    add_column :meta_data, :version_comment, :binary, :limit => 10.megabyte
  end

  def self.down
    remove_column :meta_data, :version_comment
  end
end

However, it gives the following error message:

PGError: ERROR: type modifier is not allowed for type "bytea" LINE 1: ..."meta_data" ADD COLUMN "version_comment_extended" bytea(1048... ^ : ALTER TABLE "meta_data" ADD COLUMN "version_comment_extended" bytea(10485760)

Any idea?

Please note that I am using PostgreSQL. Thanks!

amit_saxena · Accepted Answer · 2011-09-05 21:27:09Z

13

The migration seems to be correct except the down part. It should be:

class AddVersionCommentToMetaData < ActiveRecord::Migration
  def self.up
    add_column :meta_data, :version_comment, :binary, :limit => 10.megabyte
  end

  def self.down
    remove_column :meta_data, :version_comment
  end
end

double check for typos. And what version of rails are you using? It works well in rails 3.0.7.

answered Sep 5, 2011 at 21:27

amit_saxena

7,6346 gold badges53 silver badges67 bronze badges

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

1 Comment

Amokrane Chentir Over a year ago

Actually I made the typo when copy pasting on StackOverflow (the real column name is version_comment_extended but I made it shorter on purpose to improve the readability. I am using Rails 3.0.5.

Collectives™ on Stack Overflow

Rails - How to add a BLOB column using ActiveRecord?

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