Hello, I'm terribly sorry - while reviewing old questions, I've noticed that this one has been left unanswered for a long time.
I suspect that you have run into this issue here: https://github.com/jOOQ/jOOQ/issues/4055 jOOQ's code generator currently cannot handle overloaded table valued functions. The workaround is the one you've applied: To explicitly exclude all such functions from being generated. Best Regards, Lukas 2015-08-27 14:03 GMT+02:00 Adrian Smith <[email protected]>: > I am using jOOQ with PostgreSQL, everything is going well. However, when I > execute > > sudo apt-get install postgresql-9.3-postgis-2.1 > > > and then within PostgreSQL execute: > > > CREATE EXTENSION postgis; > > > And re-generate my Java classes with jOOQ I get fields which are > duplicated within one generated Java class, which is not allowed by the > Java compiler. For example it generates a new class "_StHistorgram.java", > which wasn't there before I added PostGIS to PostgreSQL, which contains the > lines > > /** > * The column <code>public._st_histogram.count</code>. > */ > public final TableField<_StHistogramRecord, Long> COUNT = > createField("count", org.jooq.impl.SQLDataType.BIGINT, this, ""); > > /** > * The column <code>public._st_histogram.count</code>. > */ > public final TableField<_StHistogramRecord, Long> COUNT = > createField("count", org.jooq.impl.SQLDataType.BIGINT, this, ""); > > > As you can imagine, the Java compiler rejects this code. > > Duplicate field _StHistogram.COUNT > > > When adding the following line to the jooq-configuration.xml everything > works again: > > <excludes>_?St_.*</excludes> > > > I think this is a bug in jOOQ? > > Thanks, > Adrian > > Postgres server 9.3.9 > postgresql-9.2-1002.jdbc4.jar > jooq-3.6.2.jar > Java 1.8 > > -- > 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.
