Re: Question about NOT NULL and default values.

On Fri, Oct 17, 2008 at 4:40 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
> On Thu, Oct 16, 2008 at 9:09 PM, Tim Uckun <timuckun(at)gmail(dot)com> 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?
>

There is no sequence. It's a foreign key.