On Tue, Nov 15, 2011 at 04:44:23PM +0800, Yan Chunlu 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! Why not adjust the underlying sequences to have different start values and to advance by 2? A -- Andrew Sullivan ajs@xxxxxxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
