Postgres Pro
Downloads
Home   >   mailing lists

Re: alter table serial->int - Mailing list pgsql-admin

From Erik Aronesty
Subject Re: alter table serial->int
Date
Msg-id ccd588d90711080814m1f21c4e0hedbfc1ff1acced3a@mail.gmail.com
Whole thread Raw
In response to Re: alter table serial->int  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: alter table serial->int  ("Igor Neyman" <ineyman@perceptron.com>)
List pgsql-admin
Tree view 
> "Erik Aronesty" <erik@q32.com> writes:
> > for some odd reason when i try to change a table from serial to just
> > plain "int with a default" postgres seems to ignore me.
>
> What PG version?

(PostgreSQL) 8.1.10

> The fact that you even tried that suggests that you don't understand
> very well what "serial" is.  See the manual ...

I tried to change the data type first.  Which implies I know what it means.

pgsql-admin by date:

Previous
From: "Erik Aronesty"
Date:
Subject: Re: alter table serial->int
Next
From: Alvaro Herrera
Date:
Subject: Re: alter table serial->int