Postgres Pro
Downloads
Home   >   mailing lists

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

From Yan Chunlu
Subject how to adjust auto increment id offset?
Date
Msg-id CAOA66tHb1kyy7ncpBNvmBXGPAxUzW4keR3JFtq4WSG0XSaW3DA@mail.gmail.com
Whole thread Raw
Responses Re: how to adjust auto increment id offset?  (Bèrto ëd Sèra <berto.d.sera@gmail.com>)
Re: how to adjust auto increment id offset?  (Andrew Sullivan <ajs@crankycanuck.ca>)
List pgsql-general
Tree view
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!

pgsql-general by date:

Previous
From:
Date:
Subject: Re: Client SQL Tool
Next
From: Bèrto ëd Sèra
Date:
Subject: Re: how to adjust auto increment id offset?