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@xxxxxxxxxxxxx>
To: "Bob Pawley" <rjpawley@xxxxxxx>
Cc: "Ragnar" <gnari@xxxxxxx>; "Postgresql" <pgsql-general@xxxxxxxxxxxxxx>
Sent: Sunday, September 24, 2006 4:30 PM
Subject: Re: [GENERAL] serial column
Bob Pawley <rjpawley@xxxxxxx> 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
