Hello folks, I have a table that contains a INET column:
CREATE TABLE backend_registration ( id BIGSERIAL NOT NULL PRIMARY KEY, password_hash TEXT NOT NULL, confirmation_token TEXT, created_at TIMESTAMP WITHOUT TIME ZONE NOT NULL DEFAULT now(), created_ip INET); However I can't get how to insert an address into column 'created_ip' factory.insertInto(REGISTRATION) .set(REGISTRATION.EMAIL, "[email protected]") .set(REGISTRATION.PASSWORD_HASH, "2304820984309238409237428739") .set(REGISTRATION.CREATED_IP, "::1") .execute(); ^ this does not work and I get the following error: >> ERROR: column "created_ip" is of type inet but expression is of type character varying >> Hint: You will need to rewrite or cast the expression. Is there a way to solve this issues? Should type INET be supported by jooq natively? Cheers Peter
