Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id E11AC9FCB8A for ; Thu, 8 Nov 2007 12:18:07 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 72988-02-4 for ; Thu, 8 Nov 2007 12:17:57 -0400 (AST) Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.178]) by postgresql.org (Postfix) with ESMTP id 23D549FCB8C for ; Thu, 8 Nov 2007 12:17:45 -0400 (AST) Received: by py-out-1112.google.com with SMTP id u77so459445pyb for ; Thu, 08 Nov 2007 08:17:44 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:sender:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth; bh=GzA84b0r6iJ+Yg663OPl+xXPXA8+d3BDaHeSNqgJml0=; b=aHimNBf+du8lCeFgIXJT3ky3ZeyxGOFzvSBt4mIcimid8wffUUwLpHinZPYfHebM/9dxS6mk88FHiuLW3HxUk+KFRCtHZv4WBU69ZBHV5pTmkzsfpOoTiph5Du+K0xOb1YYievYvJ5IQH2iVnSi5KAFF3BbcE1iwFGS5/TIOL1Y= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:sender:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth; b=Wifnmqo3fSM0zC5SdQ5+LaDH+rBaXzO/MRziWgv+4AbPpsHs5hlAa5ELez+MwW6ebI7Fc46hSJ2ScKjxmh5RBJMInxJqXmzbGcD5mj987jdcJh0TfFBAWNY61UdE+DYK7XBvZQ25Ue3XlYXGbHeW0pigFQRe2Q+pI3mHY68pRuI= Received: by 10.64.131.4 with SMTP id e4mr4739669qbd.1194538664221; Thu, 08 Nov 2007 08:17:44 -0800 (PST) Received: by 10.64.233.15 with HTTP; Thu, 8 Nov 2007 08:17:44 -0800 (PST) Message-ID: Date: Thu, 8 Nov 2007 11:17:44 -0500 From: "Erik Aronesty" To: pgsql-admin@postgresql.org Subject: Re: alter table serial->int In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <7625.1194412270@sss.pgh.pa.us> X-Google-Sender-Auth: f9f3f168327f6191 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/67 X-Sequence-Number: 27310 -- 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 wrote: > n Nov 7, 2007 12:11 AM, Tom Lane wrote: > > "Erik Aronesty" 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. >