Question about NOT NULL and default values.

From: "Tim Uckun" <timuckun(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Question about NOT NULL and default values.
Date: 2008-10-17 03:09:10
Message-ID: 855e4dcf0810162009k7dd76436jfa7cd87fe107b053@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hey all.

I am using postgres 8.3 with a rails application. I have a column
defined like this.

ALTER TABLE provisions ADD COLUMN provider_id integer;
ALTER TABLE provisions ALTER COLUMN provider_id SET STORAGE PLAIN;
ALTER TABLE provisions ALTER COLUMN provider_id SET NOT NULL;
ALTER TABLE provisions ALTER COLUMN provider_id SET DEFAULT 0;

In rails if I don't specify the provider_id the ORM passes a NULL in
the SQL to insert or update and the query blows up.

In order to get around that problem and removed the NOT NULL
constraint but postgres just puts the NULL value in the column instead
of the default value.

Is there a way to change this behavior so that an attempt to set the
column to NULL will result in the default value being put in the
field?

Thanks.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris 2008-10-17 03:13:01 Re: Question about NOT NULL and default values.
Previous Message Tom Lane 2008-10-17 00:36:57 Re: Drop database / database in use question