OMG! insert into p(other) is obviously the way to not have to specify the id. OTOH I thought that autoincrement was the safe way to guarantee that the id's were always incrementing. If you delete some records, can't a rowid table reuse those numbers?