Re: GUID for postgreSQL - Mailing list pgsql-general

From Tony Caduto
Subject Re: GUID for postgreSQL
Date
Msg-id 42E80D4B.5010709@amsoftwaredesign.com
Whole thread Raw
In response to Re: GUID for postgreSQL  (Scott Marlowe <smarlowe@g2switchworks.com>)
Responses Re: GUID for postgreSQL
List pgsql-general
Use Dblink and do a select off of a sequence on just one of the boxes?
You could set up a view that uses DBlink on all the boxes that points to
the master seq box.

should work.

Scott Marlowe wrote:

>So, how can two databases, not currently talking to one another,
>guarantee that their GUIDs don't collide? using a large randomly
>generated name space only reduces the chances of collision, it doesn't
>actually guarantee it.
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faq
>
>
>


pgsql-general by date:

Previous
From: "Thomas F. O'Connell"
Date:
Subject: Re: Upgrading from 7.1
Next
From: Alvaro Herrera
Date:
Subject: Re: duplicate messages?