On Dec 4, 2006, at 3:53 PM, Raymond O'Donnell wrote:
> On 4 Dec 2006 at 15:40, Bob Pawley wrote:
>
>> When a row is deleted the serial number and oid are also deleted. The
>> sequence then has gaps which are inadmissible.
>
> This is an issue which has come up at various times on this list in
> the past - it may be worth having a look through the archives. Here's
> one recent thread:
>
> http://archives.postgresql.org/pgsql-general/2006-08/msg00535.php
Or, better, http://archives.postgresql.org/pgsql-general/2006-09/
msg00948.php
I'm sure that PG Admin just generates the numbers in the GUI as it
displays them (as they're meaningless as persistent data).
Cheers,
Steve