From: Erik Aronesty <erik@q32.com>
To: pgsql-admin@postgresql.org
Subject: Re: alter table serial->int
Date: Thu, 8 Nov 2007 11:17:44 -0500
Message-ID: <ccd588d90711080817j482f1d39n80dee4334383ab51@mail.gmail.com> (raw)
In-Reply-To: <ccd588d90711080813j45a1cbd4u2f789e25fcc16162@mail.gmail.com>
References: <ccd588d90711061359m57d95921mc28b74dec9f35f54@mail.gmail.com>
<7625.1194412270@sss.pgh.pa.us>
<ccd588d90711080813j45a1cbd4u2f789e25fcc16162@mail.gmail.com>
-- Simpler example for you
CREATE TABLE x (
id serial NOT NULL
);
ALTER TABLE x alter id type int;
-- Under 8.1.10, a call to pg_dump will reveal the change has not happened
On Nov 8, 2007 11:13 AM, Erik Aronesty <erik@q32.com> wrote:
> n Nov 7, 2007 12:11 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> > "Erik Aronesty" <erik@q32.com> writes:
> > > for some odd reason when i try to change a table fromserial 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.
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: erik@q32.com
Subject: Re: alter table serial->int
In-Reply-To: <ccd588d90711080817j482f1d39n80dee4334383ab51@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox