Postgres Pro
Downloads
Home   >   mailing lists

Re: how to adjust auto increment id offset? - Mailing list pgsql-general

From Bèrto ëd Sèra
Subject Re: how to adjust auto increment id offset?
Date
Msg-id CAKwGa_-6GqdEr4Nx6qP_KYEqzKU38mVSPd6UU4pS+UXnDAunOQ@mail.gmail.com
Whole thread Raw
In response to how to adjust auto increment id offset?  (Yan Chunlu <springrider@gmail.com>)
Responses Re: how to adjust auto increment id offset?  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Tree view
Hi

On 15 November 2011 11:44, Yan Chunlu <springrider@gmail.com> wrote:
I would like to implement two master db with even-odd id sharding.   in mysql it is fairly easy by using the configuration:

auto_increment_offset = 1
auto_increment_increment = 2


but I have searched a lot didn't find anything related to this, some users doing this via trigger like "rubyrep". 

is there an easy way to do this?  thanks!

http://www.postgresql.org/docs/8.1/static/sql-createsequence.html

--
==============================
If Pac-Man had affected us as kids, we'd all be running around in a darkened room munching pills and listening to repetitive music.

pgsql-general by date:

Previous
From: Yan Chunlu
Date:
Subject: how to adjust auto increment id offset?
Next
From: Robins Tharakan
Date:
Subject: Re: Client SQL Tool