https://kotlinlang.org logo
#server
Title
# server
a

ahmad

02/16/2023, 8:59 AM
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
Copy code
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?
j

Joe

02/17/2023, 5:19 PM
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
88 Views