Postgres Pro
Downloads
Home   >   mailing lists

where's the gap in the sequence ? - Mailing list pgsql-novice

From Zouari Fourat
Subject where's the gap in the sequence ?
Date
Msg-id 621eda8a05031920176ec3f713@mail.gmail.com
Whole thread Raw
Responses Re: where's the gap in the sequence ?
Re: where's the gap in the sequence ?
List pgsql-novice
Tree view 
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 by date:

Previous
From: uday kumar
Date:
Subject: error http status 404: unable to locate resource
Next
From: Bruno Wolff III
Date:
Subject: Re: where's the gap in the sequence ?