[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