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/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
