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
>
>
>