Re: Question about NOT NULL and default values.

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