Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id C0E319F9244 for ; Sun, 11 Nov 2007 08:15:13 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 12460-03 for ; Sun, 11 Nov 2007 08:14:58 -0400 (AST) Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.180]) by postgresql.org (Postfix) with ESMTP id 4F2AC9F99EB for ; Sun, 11 Nov 2007 08:15:04 -0400 (AST) Received: by py-out-1112.google.com with SMTP id u77so727135pyb for ; Sun, 11 Nov 2007 04:15:02 -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=4YTqo3wzIG1wQCjfkoFCbHUDlEVF0bVD8cL0VAWb99c=; b=Hf8EvpXV8DUCVB3ExRM3cPkOE2leGn127jfcTWs8qr3oMkA0oyamlu6MzsfR5OndfJHD+Mzn75/JJZFtwNjeVCCQ6GRPUl3QeGqGxTxeeWU4AvYWjNgtS4OBDHgG1rXmk73j+MIsjrMtvxUiu7ei1yg38rX0MXphYtK8kkv0b/4= 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=dG2Ef7kvdTjrhpaZRac4/QAL4Wut34YjfT+abXflzbCa130CDGghH5L3CLZHLymPva7r6xHeoUJRDWJcq1pi6YO2tsafEBnbaJs4enk2dIXG9MON6m8xZR6GWyFYvXUftBBzbGNbYgHBx91WtLtLnqnFbEBI+8sbzARIOBk+42g= Received: by 10.65.220.8 with SMTP id x8mr11276478qbq.1194783301951; Sun, 11 Nov 2007 04:15:01 -0800 (PST) Received: by 10.64.233.15 with HTTP; Sun, 11 Nov 2007 04:15:01 -0800 (PST) Message-ID: Date: Sun, 11 Nov 2007 07:15:01 -0500 From: "Erik Aronesty" To: "Erik Aronesty" , pgsql-admin@postgresql.org Subject: Re: alter table serial->int In-Reply-To: <20071108195721.GU2938@alvh.no-ip.org> 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> <20071108195721.GU2938@alvh.no-ip.org> X-Google-Sender-Auth: 196897f7f734e716 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/91 X-Sequence-Number: 27334 CREATE TABLE x ( a serial NOT NULL ); alter table x alter a drop default; alter table x alter a set default 999; still doesn't help. i supposed i can dump the whole table and rebuild it.... but that's going to be a bit slow.