Skip site navigation (1) Skip section navigation (2)

where's the gap in the sequence ?

From: Zouari Fourat <fourat(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: where's the gap in the sequence ?
Date: 2005-03-20 04:17:03
Message-ID: 621eda8a05031920176ec3f713@mail.gmail.com (view raw or flat)
Thread:
Lists: 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

Responses

pgsql-novice by date

Next:From: Bruno Wolff IIIDate: 2005-03-20 05:46:26
Subject: Re: where's the gap in the sequence ?
Previous:From: Edward MacnaghtenDate: 2005-03-20 00:21:00
Subject: Re: MS Access to PostgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group