Hmm, I was a bit too pessimistic on that feature then. Being from the Oracle world, I wanted stay on the safe side and not run into overflows. But if that's how sequences are defined in Postgres, then BigInteger is not the right type.
I filed this as #718: https://sourceforge.net/apps/trac/jooq/ticket/718 Let's see how this can be solved... 2011/7/5 Sander Plas <[email protected]>: > Here's another "is this a bug or a feature?" question: > > Sequences in PostgreSQL are (according to the docs) "based on bigint > arithmetic" and are mapped to BigInteger in jOOQ. > > Table columns with type 'bigint' are mapped to Long. > > As a result, sequence values cannot be assigned to these columns > without converting them to Long first.
