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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
