Re: serial column - Mailing list pgsql-general

From Bob Pawley
Subject Re: serial column
Date
Msg-id 010601c6e046$cc0a08a0$8e904618@owner
Whole thread Raw
In response to serial column  (Bob Pawley <rjpawley@shaw.ca>)
Responses Re: serial column
List pgsql-general
The numbering system is more complex than just assigning a number. It
invloves about thirty procedures which I have put together and find that it
works well.

I would like to keep the numbering as a database system which will be
possible if I can figure out a way of generating sequential numbers without
possibility of a gap.

Perhaps a manually built table is the answer??

Bob


----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Bob Pawley" <rjpawley@shaw.ca>
Cc: "Ragnar" <gnari@hive.is>; "Postgresql" <pgsql-general@postgresql.org>
Sent: Sunday, September 24, 2006 4:30 PM
Subject: Re: [GENERAL] serial column


> Bob Pawley <rjpawley@shaw.ca> writes:
>> I am using the numbers to identify devices.
>> If a device is deleted or replaced with another type of device I want the
>> numbering to still be sequential.
>
> It sounds to me like you oughtn't be storing these numbers in the
> database at all.  You just want to attach them at display time --- they
> are certainly utterly meaningless as keys if they can change at any
> moment.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>


pgsql-general by date:

Previous
From: Bob Pawley
Date:
Subject: Re: serial column
Next
From: Adrian Klaver
Date:
Subject: Re: Restart after poweroutage