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
