Postgres Pro
Downloads
Home   >   mailing lists

vacuum and serial primary keys - Mailing list pgsql-sql

From Carmen Marincu
Subject vacuum and serial primary keys
Date
Msg-id Pine.GSO.4.40.0302011244410.20287-100000@khumbu
Whole thread Raw
In response to update and IN vs. EXISTS  (pginfo <pginfo@t1.unisoftbg.com>)
Responses Re: vacuum and serial primary keys  ("D'Arcy J.M. Cain" <darcy@druid.net>)
List pgsql-sql
Tree view 
Hello -

I am using Postgresql 7.1.3 and I have deleted 3000 rows from a table
(with DELETE).
Than I used vacuum <mytable> 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

pgsql-sql by date:

Previous
From: pginfo
Date:
Subject: update and IN vs. EXISTS
Next
From: "D'Arcy J.M. Cain"
Date:
Subject: Re: vacuum and serial primary keys