vacuum and serial primary keys

Поиск
Список
Период
Сортировка
От Carmen Marincu
Тема vacuum and serial primary keys
Дата
Msg-id Pine.GSO.4.40.0302011244410.20287-100000@khumbu
обсуждение исходный текст
Ответ на update and IN vs. EXISTS  (pginfo <pginfo@t1.unisoftbg.com>)
Ответы Re: vacuum and serial primary keys  ("D'Arcy J.M. Cain" <darcy@druid.net>)
Список 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




В списке pgsql-sql по дате отправления:

Предыдущее
От: pginfo
Дата:
Сообщение: update and IN vs. EXISTS
Следующее
От: "D'Arcy J.M. Cain"
Дата:
Сообщение: Re: vacuum and serial primary keys