Re: Re: serial properties - Mailing list pgsql-general

From Lincoln Yeoh
Subject Re: Re: serial properties
Date
Msg-id 3.0.5.32.20010303121506.01046340@192.228.128.13
Whole thread Raw
In response to Re: serial properties  ("Gregory Wood" <gregw@com-stock.com>)
List pgsql-general
At 11:11 AM 3/2/01 -0800, adb wrote:
>I agree that they are very handy.  They become a major pain in
>the butt when you start doing replication between servers.
>For instance if you fail over to a standby server and you
>forget to update it's sequence first, merging data later
>becomes a nightmare.  I'd like to have int8 sequences and
>basically give each server it's own block of numbers to work
>with.

Yah. I'd like int8 sequences too.

Server number X starts with X, increment by 256.

Then again maybe blocks of numbers may be better.

What happens if a sequence hits the end?

Cheerio,
Link.


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Table rule does not work!
Next
From: Doug McNaught
Date:
Subject: Re: how to vacuum from cron?