JOOQ不从PostgreSql生成表值重载过程 [英] JOOQ not generating table-valued overloaded procedures from PostgreSql

问题描述

我的 PostgreSql 表值 重载过程$ c>数据库。它们具有相同的名称，但参数数量不同。当 JOOQ 3.5 将这些过程视为表时，生成器发现仅一个过程的名称。它是以此方式设计的，还是有解决方法？

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 并没有帮助，因为当$ database.getTables（schema ）调用 Generator 中的。

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

推荐答案

这是jOOQ 3.5.2中的错误（＃4055 ）。 jOOQ当前不支持重载的表值函数。

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

我能想到的唯一解决方法是求助于普通SQL 用于这些功能。

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

这篇关于JOOQ不从PostgreSql生成表值重载过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！