On Thu, Oct 16, 2008 at 9:09 PM, Tim Uckun <timuckun@xxxxxxxxx> 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; Hold on, when did you assign a sequence to this column? When you created it as a serial? Or is there none assigned? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
