vacuum and serial primary keys

From: Carmen Marincu <marincuc(at)eeng(dot)dcu(dot)ie>
To: pgsql-sql(at)postgresql(dot)org
Subject: vacuum and serial primary keys
Date: 2003-02-01 12:45:24
Message-ID: Pine.GSO.4.40.0302011244410.20287-100000@khumbu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message pginfo 2003-02-01 13:49:46 Re: update and IN vs. EXISTS
Previous Message pginfo 2003-02-01 11:40:00 update and IN vs. EXISTS