Joe Ruby MUDCRAP-CE wrote the following on 15.10.2006 22:12 :
This seems pretty brain dead:
add_column :types, :notify_on_create, :boolean, {:default=>true, :null=>false}
$ rake migrate
Error: ERROR: column "notify_on_create" contains null values : ALTER TABLE types ALTER notify_on_create SET NOT NULL
Why doesn't Rails set the new column to true, as it's supposed to default to? I tried :default=>1 as well (same results).
Is there a way to make this migration work?
Joe
Do you use PostgreSQL by any chance?
Try to load this in your environment.rb:
# add_column in the original PostgreSQLAdapter # begins by creating the column and then adds constraints # which simply doesn't work... AbstractAdapter is ok -> super works class ActiveRecord::ConnectionAdapters::PostgreSQLAdapter def add_column(table_name, column_name, type, options = {}) super end end
Lionel
