Re: Shared Sequences? - Mailing list pgsql-general

From Ragnar Hafstað
Subject Re: Shared Sequences?
Date
Msg-id 1104705010.11499.3.camel@localhost.localdomain
Whole thread Raw
In response to Re: Shared Sequences?  ("C. Duncan Hudson" <postgresql@dunc-it.com>)
List pgsql-general
On Sun, 2005-01-02 at 16:19 -0500, C. Duncan Hudson wrote:

[about databases sharing a sequence]

>                   I have 3 instances of the application
> (each for a different business unit) and I don't want them generating
> the same numbers for different things.  I want the numbers, across all
> business units, to be truly chronological - so I'd like them to share
> the same sequence.

do you realize that sequences are not garanteed to be "chronological"?

gnari




pgsql-general by date:

Previous
From: John Sidney-Woollett
Date:
Subject: Re: Select number of children of a parent query
Next
From: "alexandre::aldeia digital"
Date:
Subject: Index, Tablespace and performance