Rails Postgre issue: malformed array literal, Array value must start with "{" or dimension information

Question

I created a new migration for my Rails app on Heroku. It adds some Array columns like this:

t.string :timezone, array: true, default: [].to_yaml
t.string :locale, array: true, default: [].to_yaml

I get the following error when I try to migrate:

ActiveRecord::StatementInvalid: PG::InvalidTextRepresentation: ERROR: malformed array literal: "--- [] " DETAIL: Array value must start with "{" or dimension information. : CREATE TABLE "filters" ("id" serial primary key, "letter_id" integer, "gender" character varying, "timezone" character varying[] DEFAULT '--- [] ', "locale" character varying[] DEFAULT '--- []

Here is my model:

class Filter < ApplicationRecord
  belongs_to :letter
  serialize :timezone
  serialize :locale
  serialize :segment
  validates_uniqueness_of :letter_id
end

Some people on Stackoverflow say removing serialize will do the trick but I need to store an array, not a string.

Any idea how I can solve this issue?

NM Pennypacker · Accepted Answer · 2017-10-02 14:35:07Z

0

Why don't you just do:

t.text :your_table, :timezone, default: []
t.text :your_table, :locale, default: []

Not sure why you would ever call to_yaml for a default value. Also, you should use a column type of text since string will likely limit you to 255 characters by default.

answered Oct 2, 2017 at 14:35

NM Pennypacker

6,99211 gold badges38 silver badges41 bronze badges

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

Comments

nico_lrx · Accepted Answer · 2017-10-02 14:54:24Z

0

In the end, I did the following and it solved my issue:

t.string :timezone, :string
t.string :locale, :string

And kept my model with serialize.

answered Oct 2, 2017 at 14:54

nico_lrx

3003 gold badges23 silver badges39 bronze badges

Collectives™ on Stack Overflow

Rails Postgre issue: malformed array literal, Array value must start with "{" or dimension information

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related