JOOQ not generating table-valued overloaded proced

问题:

I have several table-valued overloaded procedures in my PostgreSql database. They have the same name, but different number of parameters. As JOOQ 3.5 treats those procedures as tables, generator discovers only one procedure with that name. Is it designed this way, or is there a workaround?

GeneratorStrategy doesn't help as this happens earlier, when database.getTables(schema) in Generator is Called.

回答1:

This is a bug (#4055) in jOOQ 3.5.2. jOOQ currently doesn't support overloaded table-valued functions.

The only workaround I can think of is to resort to plain SQL for those functions.