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

From: Bill Moran <wmoran(at)collaborativefusion(dot)com>
To: kjohnson(at)voiceandnetworksystems(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: FW: make rows unique across db's without UUIP on windows?
Date: 2008-06-03 12:57:05
Message-ID: 20080603085705.751e0b1b.wmoran@collaborativefusion.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In response to "Kimball Johnson" <kjohnson(at)voiceandnetworksystems(dot)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(at)collaborativefusion(dot)com
Phone: 412-422-3463x4023

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2008-06-03 13:23:04 Re: Database growing. Need autovacuum help.
Previous Message Per Lauvås 2008-06-03 12:56:55 Failing to recover after panic shutdown