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 ?
pgsql-novice by date
|Next:||From: Bruno Wolff III||Date: 2005-03-20 05:46:26|
|Subject: Re: where's the gap in the sequence ?|
|Previous:||From: Edward Macnaghten||Date: 2005-03-20 00:21:00|
|Subject: Re: MS Access to PostgreSQL|