From: D'Arcy J.M. Cain <darcy@druid.net>
To: Carmen Marincu <marincuc@eeng.dcu.ie>
To: pgsql-sql@postgresql.org
Subject: Re: vacuum and serial primary keys
Date: Sat, 1 Feb 2003 09:16:08 -0500
Message-ID: <200302010916.08465.darcy@druid.net> (raw)
In-Reply-To: <Pine.GSO.4.40.0302011244410.20287-100000@khumbu>
References: <Pine.GSO.4.40.0302011244410.20287-100000@khumbu>
On Saturday 01 February 2003 07:45, Carmen Marincu wrote:
> 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 ?
It is very normal. The last thing you need is a database engine that changes
your primary key without an explicit command to do so. In fact, sometimes I
think that the database should enforce the rule that primary keys are
immutable and not even allow it explicitely. Perhaps a configuration option.
--
D'Arcy J.M. Cain <darcy@{druid|vex}.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: darcy@druid.net, marincuc@eeng.dcu.ie
Subject: Re: vacuum and serial primary keys
In-Reply-To: <200302010916.08465.darcy@druid.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox