Add NOT NULL column with default value as empty string in Rails

Question

I am new to Ruby on Rails and trying to achieve this:

I want to add a string column which is NOT NULL and holds the default value ''.

Here is my migration:

add_column :campaigns, :from_name, :string, limit: 100, :null => false, :defualt => ''

This migration works fine but when I see table in pgAdmin (PostgresQL) I see columns created but no default value:

from_name character varying(100) NOT NULL,

I tried same thing using pgAdmin and I could create

from_name character varying(100) NOT NULL DEFAULT ''::character varying,

What is wrong here??

You have a typo in your migration, ":defualt". So unless that's a copy error I suggest that's your problem. — Mike Campbell
– Mike Campbell, Commented Mar 5, 2013 at 10:42
Oh God! I feel very stupid having spent 2 hrs on this :( thanks a lot @MikeCampbell — pramodtech
– pramodtech, Commented Mar 5, 2013 at 10:49
@MikeCampbell just wonder why it didn't give any error/warning? — pramodtech
– pramodtech, Commented Mar 5, 2013 at 10:58
@Pramodtech Rails ignores arbitrary named parameters that are passed to migrations. — tamizhgeek
– tamizhgeek, Commented Mar 5, 2013 at 11:14
heh, no worries, we've all done it. and yep, @tamizhgeek is right. — Mike Campbell
– Mike Campbell, Commented Mar 5, 2013 at 11:48

brunocalado · Accepted Answer · 2013-03-25 20:56:35Z

7

It looks like you typed: defualt instead of default.

Try to fix that.

answered Mar 25, 2013 at 20:56

brunocalado

1367 bronze badges

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

1 Answer 1