Re: PG Admin - Mailing list pgsql-general

From Bob Pawley
Subject Re: PG Admin
Date
Msg-id 017c01c71812$abc438f0$8e904618@owner
Whole thread Raw
In response to PG Admin  (Bob Pawley <rjpawley@shaw.ca>)
Responses Re: PG Admin  (Alban Hertroys <alban@magproductions.nl>)
List pgsql-general
Perhaps - but they aren't necessarily meaningless as pure information.

Bob


----- Original Message -----
From: "Steve Atkins" <steve@blighty.com>
To: "PgSQL General" <pgsql-general@postgresql.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
>

pgsql-general by date:

Previous
From: Steve Atkins
Date:
Subject: Re: PG Admin
Next
From: Richard Broersma Jr
Date:
Subject: Re: PG Admin