X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 4B057475F2F for ; Sat, 1 Feb 2003 07:45:23 -0500 (EST) Received: from khumbu.eeng.dcu.ie (list.eeng.dcu.ie [136.206.35.10]) by postgresql.org (Postfix) with ESMTP id B1443475F28 for ; Sat, 1 Feb 2003 07:45:22 -0500 (EST) Received: from marincuc (helo=localhost) by khumbu.eeng.dcu.ie with local-esmtp (Exim 4.12) id 18ex1Q-0005Ht-00 for pgsql-sql@postgresql.org; Sat, 01 Feb 2003 12:45:24 +0000 Date: Sat, 1 Feb 2003 12:45:24 +0000 (GMT) From: Carmen Marincu X-X-Sender: marincuc@khumbu To: pgsql-sql@postgresql.org Subject: vacuum and serial primary keys In-Reply-To: <3E3BB210.5C51478C@t1.unisoftbg.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/6 X-Sequence-Number: 11404 Hello - I am using Postgresql 7.1.3 and I have deleted 3000 rows from a table (with DELETE). Than I used vacuum to actually delete the rows markes as deleted by the DELETE command.. The trouble is that the "counter" for the serial primary key (ID field) wasn't reset. So now althought I have only 2 rows in my table they have the ID 3001 and 3002. Is this normal ? If not could someone please explain me how could I reset the "counter" to ignore the deleted rows ? Thank you very much Carmen