DAO for table with inheritance (postgres), table is no UpdateableRecord

2018-07-11 Thread drekowski
Hello, I have a postgres table with inheritance, I want to write a DAO for, which I want to derive from DAOImpl. Now DAOImpl expects the table to be of type UpdatetableRecord: DAOImpl, P, T>. What would be the best way to implement a class working on an inherited table with jOOQ? Best

Re: DAO for table with inheritance (postgres), table is no UpdateableRecord

2018-07-11 Thread Lukas Eder
Hello David, I'm assuming you plan to be using the code generator, which unfortunately does not support PostgreSQL table inheritance yet. There are a few pending feature requests: - https://github.com/jOOQ/jOOQ/issues/2777 - https://github.com/jOOQ/jOOQ/issues/2782 Also related: Oracle OBJECT

Re: DAO for table with inheritance (postgres), table is no UpdateableRecord

2018-07-11 Thread drekowski
Hello Lucas, the use case is I want to store typed metadata, e.g. numbers, strings, boolean and geolocation, like this: CREATE TYPE meta.metadata_type AS ENUM ('int32', 'float64', 'string', 'lnglat', 'boolean'); CREATE TABLE meta.metadata ( uuid uuid NOT NULL,