Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 3224C9FB40B for ; Sat, 21 Oct 2006 12:57:58 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 80713-03 for ; Sat, 21 Oct 2006 15:56:15 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web31805.mail.mud.yahoo.com (web31805.mail.mud.yahoo.com [68.142.207.68]) by postgresql.org (Postfix) with SMTP id F1E549FB5D4 for ; Sat, 21 Oct 2006 12:25:56 -0300 (ADT) Received: (qmail 78842 invoked by uid 60001); 21 Oct 2006 15:25:55 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=JGRBX/LIrAsJAXf1p68fl78wpWzM2fxVF/+Y+L8Yx3Yu1+s5lb146JZoPYy4tBVxCygOt22Mu4+vA17P6B1+7qYoF9F2Qj9qVQ4Bv9HXAL122DetO6CVdG3CYSg5W6SsHFqwGLWVptu3ZWG1JMIqW2RMFFyNoBHp+PYaQs8cXoI= ; Message-ID: <20061021152555.78840.qmail@web31805.mail.mud.yahoo.com> Received: from [24.54.196.198] by web31805.mail.mud.yahoo.com via HTTP; Sat, 21 Oct 2006 08:25:54 PDT Date: Sat, 21 Oct 2006 08:25:54 -0700 (PDT) From: Richard Broersma Jr Subject: Re: [HACKERS] Bug? To: Indira Muthuswamy , "Jim C. Nasby" Cc: pgsql-sql@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.355 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS X-Spam-Level: *** X-Archive-Number: 200610/193 X-Sequence-Number: 26582 > Then how do we clear the values of a serial column(is it done only by > dropping the column?)? If you look at the following link, you will see that serial is not really a true data-type. It is merely a short-cut to get the desired results: http://www.postgresql.org/docs/8.1/interactive/datatype.html#DATATYPE-SERIAL Also, if you are interested in resetting your columns "serial" value back to 1 or 0 or -10000, you can do it using the setval() function for the following link: http://www.postgresql.org/docs/8.1/interactive/functions-sequence.html Regards, Richard Broersma Jr.