> That did the trick and solved all the issues! > Using: > Factory create=new PostgresFactory(conn); > instead of > Sch1Factory create=new Sch1Factory(conn); > all the queries are correctly generated with schema prefixes.
Great! > Now I better understand the purpose of the [Schema-Name]Factory classes > with respect to the generic ones. Yes, that was not obvious from the manual and / or code. I'll have jooq-codegen generate some Javadoc comments into the [Schema-Name]Factory classes: https://sourceforge.net/apps/trac/jooq/ticket/1449 > Generating the classes for the whole db (no <inputSchema>) one can also > conveniently make queries an tables of all schemas. > Maybe this is worth mentioning in a clearer way in the docs. You're probably right. This might not be clear enough. I'll fix the manual. > I will experiment some more in particular with geospatial usage and report > any findings. Great, thanks for your input Cheers Lukas
