where's the gap in the sequence ?

Поиск
Список
Период
Сортировка
От Zouari Fourat
Тема where's the gap in the sequence ?
Дата
Msg-id 621eda8a05031920176ec3f713@mail.gmail.com
обсуждение исходный текст
Ответы Re: where's the gap in the sequence ?  (Bruno Wolff III <bruno@wolff.to>)
Re: where's the gap in the sequence ?  (Michael Fuhr <mike@fuhr.org>)
Список pgsql-novice
Hello
i have a column 'id' wich is a sequence incremented by 1
i did a verification on my table and found that i probably got some
lines deleted from the table.
i compared the count(*) and the max(id) and found that there is a
difference of 400 lines.
how to seek that gap in my table ? i want to know wich id value every
line from the 400 deleted lines got.
how to do it ?
thanks

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

Предыдущее
От: uday kumar
Дата:
Сообщение: error http status 404: unable to locate resource
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: where's the gap in the sequence ?