Received: from localhost.localdomain (postgresql.org [64.49.215.8])
	by localhost (Postfix) with ESMTP id D3479476208
	for <pgsql-sql@postgresql.org>; Thu,  6 Jun 2002 07:18:05 -0400 (EDT)
Received: from kitana.asti.dost.gov.ph (kitana.asti.dost.gov.ph
 [202.90.128.8])
	by postgresql.org (Postfix) with ESMTP id 66A7347603F
	for <pgsql-sql@postgresql.org>; Thu,  6 Jun 2002 07:15:44 -0400 (EDT)
Received: from asti.dost.gov.ph (askr.asti.dost.gov.ph [10.10.5.36])
	by kitana.asti.dost.gov.ph (Postfix) with ESMTP id 06F4825811
	for <pgsql-sql@postgresql.org>; Thu,  6 Jun 2002 19:13:15 +0800 (PHT)
Message-ID: <3CFFF865.A0A77DD@asti.dost.gov.ph>
Date: Thu, 06 Jun 2002 20:03:49 -0400
From: Joseph Syjuco <joseph@asti.dost.gov.ph>
Organization: Advanced Science and Technology Institute
X-Mailer: Mozilla 4.78 [en] (X11; U; Linux 2.4.8-26mdk i586)
X-Accept-Language: en
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: how to reset serials
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200206/49
X-Sequence-Number: 8014

how can i reset my serial field to 0.  Tried using setval but it only
allows setting of my next serial to 2
joseph