Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 2708C9FC360 for ; Fri, 11 May 2007 20:31:04 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 29186-04 for ; Fri, 11 May 2007 20:30:48 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id AAD759FC31C for ; Fri, 11 May 2007 19:57:18 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr4.postgresql.org (Postfix) with ESMTP id C8CEB5AF032 for ; Fri, 11 May 2007 20:43:16 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l4BKWYGu002959; Fri, 11 May 2007 16:32:34 -0400 (EDT) To: "=?ISO-8859-1?Q?Rodrigo_De_Le=F3n?=" Cc: pgsql-sql@postgresql.org, "Collin Peters" Subject: Re: Convert serial column to regular integer In-reply-to: References: Comments: In-reply-to "=?ISO-8859-1?Q?Rodrigo_De_Le=F3n?=" message dated "Fri, 11 May 2007 11:36:25 -0500" Date: Fri, 11 May 2007 16:32:33 -0400 Message-ID: <2958.1178915553@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/92 X-Sequence-Number: 28372 "=?ISO-8859-1?Q?Rodrigo_De_Le=F3n?=" writes: > On 5/11/07, Collin Peters wrote: >> Is there any way to remove the sequence fully? > ALTER SEQUENCE dtab_i_seq OWNED BY NONE; Pre-8.2 that command doesn't exist, but you can get the same effect if you manually remove the pg_depend entry that links the sequence to the column. Be sure you're removing the right entry ;-) regards, tom lane