On 02/23/2011 05:09 PM, Rich Shepard wrote:
> On Wed, 23 Feb 2011, Joshua D. Drake wrote:
>
>> alter table drop constraint
>> alter table drop column
>> alter table add primary key
>>
>> done
>
> Thanks, Josh.
>
> When I do this and follow with '\d water_well' I still see the first
> column (sequence_no) with the not null constraint. Wonder why that didn't
> drop when I specified the column name in the drop column command.
Did you COMMIT; ?