Null constraint error while Default value is set Ruby On Rails - Postgresql

Question

In my database i have a table with schema like below

  create_table "external_source", force: :cascade do |t|
    t.string   "external_id"
    t.string   "permalink",                             null: false
    t.datetime "created_at",                            null: false
    t.datetime "updated_at",                            null: false
    t.boolean  "is_deleted",         default: false,    null: false
    t.string   "company_name",       default: ""
    t.boolean  "hide_salary",        default: true,     null: false
  end

But when i tried to insert values without is_deleted parameter, Rails server throws null constraint violation error like:

ActiveRecord::StatementInvalid (PG::NotNullViolation: ERROR: null value in column "is_deleted" violates not-null constraint

Now when I have set its default value I am not expecting this error. can you tell me what wrong am I doing. Thank You

here is the JSON to insert

{
  "data":
  [
    {
      "external_id":"2262a0228sf-1b9e-sd4e76-b5d7-a8ba01783ebb9i3413139",
      "permalink": '234242341',
      "hide": true,
      "company_name": "com1",
    }
  ]
}

Please post the code that does the create statement. – Anton Jul 14 '18 at 12:56 — Anton, Jul 14 '18 at 12:56
Great! Please add the controller code as well. – Anton Jul 14 '18 at 13:13 — Anton, Jul 14 '18 at 13:13

score 2 · Answer 1 · answered Jul 14 '18 at 14:32

2

null and default have different purposes in the migration. If you want the default value to be set as false, when no value is set in the controller just use,

default: false,

there is no need to use the null:false parameter in your case. default would do the work for you. For more explanation of null and default please check the following link How do :default => 0 and :null => false differ for integer fields in migrations?

answered Jul 14 '18 at 14:32

Shabini Rajadas

731
8
15

i was doing this thing before which didn't worked so i added `null: false` which also didn't work – Mani Jul 14 '18 at 17:00
Can you please add the controller code used for creation. – Shabini Rajadas Jul 14 '18 at 17:56
What does ExternalSource.new display in rails console? – Shabini Rajadas Jul 14 '18 at 18:08
sorry for late reply. internet is really bad. yeah that shows the default values. i check. – Mani Jul 14 '18 at 18:14
Then there is something wrong with the controller code. Remove the null: false from the migration file and check the code in controller. – Shabini Rajadas Jul 14 '18 at 18:25
that answer you link seems to rely on mysql brokenness,. – Jasen Jul 14 '18 at 22:45

score 0 · Answer 2 · answered Jul 16 '18 at 13:56

0

Maybe there is a validation in model, sth like validates :is_deleted, presence: true? if so:

get rid of this validation, or
keep validation and set as false by default (if missing), i.e.
```
def default_deleted_status
  self.status ||= false
end
```

answered Jul 16 '18 at 13:56

MaciekR

262
3
17

Null constraint error while Default value is set Ruby On Rails - Postgresql

2 Answers2