Re: table with sort_key without gaps - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: table with sort_key without gaps
Date
Msg-id 20041213191107.GC11248@wolff.to
Whole thread Raw
In response to Re: table with sort_key without gaps  (Janning Vygen <vygen@gmx.de>)
List pgsql-general
On Mon, Dec 13, 2004 at 19:37:41 +0100,
  Janning Vygen <vygen@gmx.de> wrote:
>
> the other reason why i wanted gapless sequences was that i would love to use
> the id in an URL. But this is easy to manage to translate a positional id in
> an URL to the database id.

For this you probably shouldn't be using the sort value (even if you use
numeric to avoid having to renumber). This should use a real primary key.
This you definitely can use a sequence for if there isn't a natural
primary key.

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: table with sort_key without gaps
Next
From: Phil Endecott
Date:
Subject: Re: Temporary tables and disk activity