Hi, I have a Ktor App with `jOOQ` plugin and `Flyw...

# server

[ahmad]

Hi, I have a Ktor App with jOOQ plugin and Flyway.
I installed the pg_partman and pg_cron extensions on the local Postgres by creating a Dockerfile.postgres file and used it in the docker-compose.yml file.
So I am able to run pg_partman and pg_cron functions on my local db.
But the generateJooqClasses fails to run those functions

ERROR: function partman.create_parent(p_parent_table => unknown, p_control => unknown, p_type => unknown, p_interval => unknown, p_premake => integer, p_start_partition => unknown, p_template_table => unknown) does not exist
  Hint: No function matches the given name and argument types. You might need to add explicit type casts.

I guess because generateJooqClasses creates its own container which doesn’t have those extensions.

Any idea how to make it work? How to make the extensions available in this container?

[Joe]

do you need the functions to be visible to/executed by jooq? if not /* [jooq ignore start] */ create_parent(...) /* [jooq ignore stop] */ type comments in your flyway scripts can be used to skip over them in the jooq generation steps. (depending on how you have jooq set up, it uses an h2 db for the schema generation step which yeah wont have those extensions). depends on exactly how you're using them if that'll work, I have an example that uses it to skip default values that rely on the uuid-ossp extension -- and the schema types etc still generate fine