Interesting, thanks for pointing this out. The quickest solutions here would be:
- Patch org.jooq.util.postgres.PostgresDatabase to run a more appropriate query in getRoutines0() - Override getRoutines0() and sort the resulting List<RoutineDefinition> using Java - Wait for jOOQ 3.10, where we introduced a new <orderProvider/> SPI to the code generator, which fixes this configuratively: https://github.com/jOOQ/jOOQ/issues/4846 I hope this helps, Lukas 2017-06-19 20:53 GMT+02:00 Kai Waldron <[email protected]>: > Hello, > > Wondering about the best ways to potentially tackle this issue. Running > jooq codegen against the same Postgres db running on Mac and Linux > (identical schema) produces slightly different results. Different in the > order stored procedures are generated in the Routines.java file, for > example. Digging into this it appears to be a known issue related to the > way OS X and Linux variants handle collation differently. For example see: > https://simply.name/pg-lc-collate.html > > So, I'm wondering what the best work around is to get a consistent > ordering across OSs here? Is there a way I can define my own ordering > function for jooq codegen? > > Cheers, > Kai > > -- > You received this message because you are subscribed to the Google Groups > "jOOQ User Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
