Re: [SQL] How to Convert Integer to Serial

Yes Done... Thanks alot...

On Fri, Oct 29, 2010 at 10:40 AM, Shoaib Mir <shoaibmir(at)gmail(dot)com> wrote:

> On Fri, Oct 29, 2010 at 4:05 PM, venkat <ven(dot)tammineni(at)gmail(dot)com> wrote:
>
>> ALTER TABLE Demotable ALTER COLUMN gid
>> SET DEFAULT nextval('serial'::regclass);
>>
>>
>> It is saying that ..serial does not exist...is that true ?
>>
>>
>>
> Please avoid sending emails to the personal email addresses but use the
> community mailing lists for that.
>
> For the error you mentioned please follow the steps I mentioned in my last
> email as you are doing it the wrong way.
>
> Create a sequence first and then you can assign that sequence to this
> column. You can not assign SERIAL like this, it has to be a sequence name in
> there.
>
> Shoaib Mir
> http://shoaibmir.wordpress.com/
>