Search Postgresql Archives
how to adjust auto increment id offset?
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
To
:
pgsql-general@xxxxxxxxxxxxxx
Subject
: how to adjust auto increment id offset?
From
: Yan Chunlu <
springrider@xxxxxxxxx
>
Date
: Tue, 15 Nov 2011 16:44:23 +0800
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!
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Follow-Ups
:
Re: how to adjust auto increment id offset?
From:
Andrew Sullivan
Re: how to adjust auto increment id offset?
From:
Bèrto ëd Sèra
Prev by Date:
Re: Client SQL Tool
Next by Date:
Re: how to adjust auto increment id offset?
Previous by thread:
syntax highlighting in emacs after \e in psql
Next by thread:
Re: how to adjust auto increment id offset?
Index(es):
Date
Thread
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]
