Re: table with sort_key without gaps

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: table with sort_key without gaps
Дата
Msg-id 20041213191107.GC11248@wolff.to
обсуждение исходный текст
Ответ на Re: table with sort_key without gaps  (Janning Vygen <vygen@gmx.de>)
Список 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 по дате отправления:

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: table with sort_key without gaps
Следующее
От: Phil Endecott
Дата:
Сообщение: Re: Temporary tables and disk activity