Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id E13CA9FA6B6 for ; Fri, 11 May 2007 20:27:58 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 39428-02-2 for ; Fri, 11 May 2007 20:27:38 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.228]) by postgresql.org (Postfix) with ESMTP id ACC569FB513 for ; Fri, 11 May 2007 19:53:33 -0300 (ADT) Received: by nz-out-0506.google.com with SMTP id s1so1194826nze for ; Fri, 11 May 2007 15:53:32 -0700 (PDT) Received: by 10.114.131.2 with SMTP id e2mr11718wad.1178914682263; Fri, 11 May 2007 13:18:02 -0700 (PDT) Received: by 10.114.37.3 with HTTP; Fri, 11 May 2007 13:18:02 -0700 (PDT) Message-ID: Date: Fri, 11 May 2007 13:18:02 -0700 From: "Collin Peters" Subject: Re: Convert serial column to regular integer Cc: pgsql-sql@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/91 X-Sequence-Number: 28371 Anything pre-8.2? On 5/11/07, Rodrigo De Le=F3n wrote: > > CREATE TABLE dtab (i SERIAL); > > ALTER TABLE dtab ALTER COLUMN i DROP DEFAULT; > > ALTER SEQUENCE dtab_i_seq OWNED BY NONE; > > DROP SEQUENCE dtab_i_seq; >