Perhaps - but they aren't necessarily meaningless as pure information.
Bob
----- Original Message -----
From: "Steve Atkins" <steve@xxxxxxxxxxx>
To: "PgSQL General" <pgsql-general@xxxxxxxxxxxxxx>
Sent: Monday, December 04, 2006 4:33 PM
Subject: Re: [GENERAL] PG Admin
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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
