Re: FW: make rows unique across db's without UUIP on windows? - Mailing list pgsql-general

From Bill Moran
Subject Re: FW: make rows unique across db's without UUIP on windows?
Date
Msg-id 20080603085705.751e0b1b.wmoran@collaborativefusion.com
Whole thread Raw
In response to FW: make rows unique across db's without UUIP on windows?  ("Kimball Johnson" <kjohnson@voiceandnetworksystems.com>)
Responses Re: FW: make rows unique across db's without UUIP on windows?  ("Kimball Johnson" <kjohnson@voiceandnetworksystems.com>)
List 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 by date:

Previous
From: Henrik
Date:
Subject: Database growing. Need autovacuum help.
Next
From: Rob Johnston
Date:
Subject: join ... using ... and - is this expected behaviour?