how to adjust auto increment id offset?

From: Yan Chunlu <springrider(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: how to adjust auto increment id offset?
Date: 2011-11-15 08:44:23
Message-ID: CAOA66tHb1kyy7ncpBNvmBXGPAxUzW4keR3JFtq4WSG0XSaW3DA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robins Tharakan 2011-11-15 08:50:00 Re: Client SQL Tool
Previous Message bjoern 2011-11-15 08:25:57 Re: Client SQL Tool