| From: | Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my> |
|---|---|
| To: | adb <adb(at)Beast(dot)COM>, Gregory Wood <gregw(at)com-stock(dot)com> |
| Cc: | PostgreSQL-General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Re: serial properties |
| Date: | 2001-03-03 04:15:06 |
| Message-ID: | 3.0.5.32.20010303121506.01046340@192.228.128.13 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Doug McNaught | 2001-03-03 04:16:28 | Re: how to vacuum from cron? |
| Previous Message | Tom Lane | 2001-03-03 00:34:15 | Re: Table rule does not work! |