Re: Question about NOT NULL and default values. - Mailing list pgsql-general

Tim Uckun wrote:
> 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.

Not sure how you do this in rails but if you use DEFAULT in the query it
works:

 > create table a(a int default 5);
CREATE TABLE

 > insert into a(a) values (DEFAULT);
INSERT 0 1

 > SELECT * from a;
  a
---
  5
(1 row)


--
Postgresql & php tutorials
http://www.designmagick.com/