Yes Done... Thanks alot...
On Fri, Oct 29, 2010 at 10:40 AM, Shoaib Mir <shoaib...@gmail.com> wrote:
> On Fri, Oct 29, 2010 at 4:05 PM, venkat <ven.tammin...@gmail.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/
>
