From: | Bob Pawley <rjpawley(at)shaw(dot)ca> |
---|---|
To: | Raymond O'Donnell <rod(at)iol(dot)ie>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: PG Admin |
Date: | 2006-12-05 00:13:37 |
Message-ID: | 013301c71802$36100810$8e904618@owner |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm doing something similar - using a control table, dropping and creating
the serial column and updating in a manner that does the job.
It works - barely. I am seeking a more elegent and stable method. Having a
simple update recognizing the row numbers (in version 1.6.1) would be
better - perhaps.
Bob
----- Original Message -----
From: "Raymond O'Donnell" <rod(at)iol(dot)ie>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Monday, December 04, 2006 3:53 PM
Subject: Re: [GENERAL] PG Admin
> 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
>
>
> --Ray.
>
>
> ----------------------------------------------------------------------
>
> Raymond O'Donnell
> Director of Music, Galway Cathedral, Galway, Ireland
> rod(at)iol(dot)ie
> ----------------------------------------------------------------------
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
From | Date | Subject | |
---|---|---|---|
Next Message | Bob Pawley | 2006-12-05 00:17:41 | Re: PG Admin |
Previous Message | Scott Marlowe | 2006-12-05 00:09:13 | Re: PG Admin |