X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id F2A4C9F946D for ; Tue, 9 May 2006 11:03:46 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 59075-10 for ; Tue, 9 May 2006 11:03:36 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from coe.tamu.edu (edsun.coe.tamu.edu [165.91.232.6]) by postgresql.org (Postfix) with ESMTP id 051509F931D for ; Tue, 9 May 2006 11:03:36 -0300 (ADT) Received: from coe.tamu.edu (coe.tamu.edu [165.91.232.6]) by coe.tamu.edu (8.11.7p2+Sun/8.12.11) with ESMTP id k49E1Sq08660; Tue, 9 May 2006 09:01:28 -0500 (CDT) Date: Tue, 9 May 2006 09:01:27 -0500 (CDT) From: "Ben K." To: Pascal Tufenkji cc: pgsql-admin@postgresql.org Subject: Re: FW: reset all sequences In-Reply-To: <200605090642.k496gTV8021264@Citrus.usj.edu.lb> Message-ID: References: <200605090642.k496gTV8021264@Citrus.usj.edu.lb> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/87 X-Sequence-Number: 21619 > Select setval('mytable_id_seq',1); > So when I insert a new row the value will be "2" and not "1" as it should be Select setval('mytable_id_seq',1,false); http://www.postgresql.org/docs/8.1/interactive/functions-sequence.html HTH. Ben K. Developer http://benix.tamu.edu