Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id A99C44764E2 for ; Thu, 6 Jun 2002 07:46:25 -0400 (EDT) Received: from wolff.to (wolff.to [66.92.219.49]) by postgresql.org (Postfix) with SMTP id B9E7D47655E for ; Thu, 6 Jun 2002 07:43:55 -0400 (EDT) Received: (qmail 8224 invoked by uid 500); 6 Jun 2002 11:48:24 -0000 Date: Thu, 6 Jun 2002 06:48:24 -0500 From: Bruno Wolff III To: Joseph Syjuco Cc: pgsql-sql@postgresql.org Subject: Re: how to reset serials Message-ID: <20020606114824.GA8206@wolff.to> Mail-Followup-To: Joseph Syjuco , pgsql-sql@postgresql.org References: <3CFFF865.A0A77DD@asti.dost.gov.ph> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <3CFFF865.A0A77DD@asti.dost.gov.ph> User-Agent: Mutt/1.3.25i X-Archive-Number: 200206/50 X-Sequence-Number: 8015 On Thu, Jun 06, 2002 at 20:03:49 -0400, Joseph Syjuco wrote: > how can i reset my serial field to 0. Tried using setval but it only > allows setting of my next serial to 2 > joseph