[Vtigercrm-developers] sequence tables vs auto_increment

Adam Heinz amh at metricwise.net
Thu Apr 26 13:02:49 PDT 2012


On Thu, Apr 26, 2012 at 3:54 PM, Nicolas Larcipretti
<niclarcipretti at gmail.com> wrote:
> Maybe portability. If you try to port all the tables to Oracle, for
> instance, auto-increment would never work. But if you control the sequences
> in a separate table, it becomes highly portable.

Oh yeah.  I don't know how I forgot that; at my last job we used
postgresql, and used SET DEFAULT NEXTVAL('table_seq').


More information about the vtigercrm-developers mailing list