With much digging through the archives, I found this example for setting the sequence when creating a table:
CREATE SEQUENCE TESTSEQ; CREATE TABLE TEST(ID INT DEFAULT NEXT VALUE FOR TESTSEQ PRIMARY KEY); However I still have no migration strategy due to the problems moving from 171 to 176. On Wednesday, May 28, 2014 3:13:46 PM UTC-7, Brian Craft wrote: > > How can I set the cache for a primary key sequence? I haven't found a way > to specify the cache when creating the column. Also haven't found a way to > specify the sequence for the column, so I can't create the sequence with > the right cache and then create a column that uses it. > > Also, the "alter sequence .. cache" command isn't working. I suspect it is > a recent addition. I will try updating. > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
