Re: FW: make rows unique across db's without UUIP on windows?

Поиск
Список
Период
Сортировка
От Bill Moran
Тема Re: FW: make rows unique across db's without UUIP on windows?
Дата
Msg-id 20080603085705.751e0b1b.wmoran@collaborativefusion.com
обсуждение исходный текст
Ответ на FW: make rows unique across db's without UUIP on windows?  ("Kimball Johnson" <kjohnson@voiceandnetworksystems.com>)
Ответы Re: FW: make rows unique across db's without UUIP on windows?  ("Kimball Johnson" <kjohnson@voiceandnetworksystems.com>)
Список pgsql-general
In response to "Kimball Johnson" <kjohnson@voiceandnetworksystems.com>:
>
> What is the normal solution in pgsql-land for making a serious number of
> rows unique across multiple databases?
>
>
>
> I mean particularly databases of different types (every type) used at
> various places (everywhere) on all platforms (even MS[TM])? You know. a
> UNIVERSAL id?

Just give each separate system it's own unique identifier and a sequence
to append to it.

--
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/

wmoran@collaborativefusion.com
Phone: 412-422-3463x4023

В списке pgsql-general по дате отправления:

Предыдущее
От: Henrik
Дата:
Сообщение: Database growing. Need autovacuum help.
Следующее
От: Rob Johnston
Дата:
Сообщение: join ... using ... and - is this expected behaviour?