[Dbix-class] Strict sequence primary key
Ronald J Kimball
rkimball+dbixclass at pangeamedia.com
Wed Jan 20 22:14:44 GMT 2010
Wes Cravens wrote:
> In an effort to create strictly sequential (Incrementing Integer no
> gaps) primary keys my method has traditionally been:
>
> BEGIN;
> LOCK table;
> SELECT MAX(id) FROM table;
> INSERT INTO table...;
> COMMIT;
>
> I'm relatively new to DBIC and have not really seen a way to do this
> unless I create a wrapper to handle it.
>
> Is there something I am missing?
Why do require strictly sequential primary keys?
Ronald
More information about the DBIx-Class
mailing list