Re: PG Admin

Perhaps - but they aren't necessarily meaningless as pure information.

Bob

----- Original Message -----
From: "Steve Atkins" <steve(at)blighty(dot)com>
To: "PgSQL General" <pgsql-general(at)postgresql(dot)org>
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
>