CODEWITHSUNDEEP
postgresqljooq
Juri Krainjukov
Juri Krainjukov

Reputation: 742

JOOQ not generating table-valued overloaded procedures from PostgreSql

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.

Upvotes: 2

Views: 369

Answers (1)

Lukas Eder
Lukas Eder

Reputation: 220952

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.

Upvotes: 1

Related Questions