Re: Shared Sequences?

From: Ragnar Hafstað <gnari(at)simnet(dot)is>
To: "C(dot) Duncan Hudson" <postgresql(at)dunc-it(dot)com>
Cc: PgSQL General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Shared Sequences?
Date: 2005-01-02 22:30:10
Message-ID: 1104705010.11499.3.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message alexandre::aldeia digital 2005-01-02 22:43:20 Index, Tablespace and performance
Previous Message ntinos 2005-01-02 21:44:23 "bogus aset link"