Joaquin, I get it now. This is just a system view from the pg_catalog schema. Just exclude that (and other items) using postgresDsl.filterSchemas() and similar methods.
I hope this helps, Lukas On Mon, Sep 8, 2025 at 4:01 PM 'Joaquin' via jOOQ User Group < jooq-user@googlegroups.com> wrote: > let me reword that: > > when I get my Oracle Schema (which has all the tables) > final Meta oracleMeta = dsl.meta(DefaultSchema.DEFAULT_SCHEMA); > and I try to apply to my postgres "jooq schema" ( postgresDsl.meta()) > which is an empty postgres DB with testcontainers. > > when trying to migrate my postgres to the oracle state ( > postgresDsl.meta().migrateTo(oracleMeta);) > > the migrations fails with this error I described before > (pg_timezone_abbrevs), so my question is, I ignore jooq is trying to create > it for the column type in oracle being (TIMESTAMP WITH LOCAL TIME ZONE) or > something else I'm missing? > > i hope it's clear now > > > On Monday, September 8, 2025 at 3:52:18 PM UTC+2 lukas...@gmail.com wrote: > >> Joaquin, >> >> I don't know what you mean by the "migration" creating that function in >> the postgres "schema" >> >> On Mon, Sep 8, 2025 at 3:21 PM 'Joaquin' via jOOQ User Group < >> jooq...@googlegroups.com> wrote: >> >>> thanks for the feedback, just a question, I ignore, why is the oracle >>> -> postgres migration creating pg_timezone_abbrevs in the postgres >>> "schema"? is that due to maybe TIMESTAMP WITH LOCAL TIME ZONE ? >>> >>> thanks >>> >>> On Thursday, September 4, 2025 at 4:30:52 PM UTC+2 lukas...@gmail.com >>> wrote: >>> >>>> Hi Joaquin, >>>> >>>> Thanks for your message. You shouldn't expect 100% coverage of all >>>> database specific SQL. jOOQ will implement more and more of these things, >>>> but you'll always run into limitations. For example, pg_timezone_abbrevs() >>>> is simply not supported, and I don't think that's something worth adding >>>> support for. >>>> >>>> You can try to extend the parser using a ParseListener: >>>> >>>> https://www.jooq.org/doc/latest/manual/sql-building/sql-parser/sql-parser-listener/ >>>> >>>> Or you could try your luck requesting new features in the parser or in >>>> jOOQ in general, if you think this is a generic enough vendor-specific >>>> feature whose translation / emulation could make sense: >>>> https://github.com/jOOQ/jOOQ/issues/new/choose >>>> >>>> I hope this helps, >>>> Lukas >>>> >>>> On Thu, Sep 4, 2025 at 1:56 PM 'Joaquin' via jOOQ User Group < >>>> jooq...@googlegroups.com> wrote: >>>> >>>>> Hello! >>>>> >>>>> I'm trying to create "migrations"(there's no much documentation atm) >>>>> from an existent DB into a testcontainer one in another dialect without >>>>> success, @Lukas it's maybe not an intended use case, but would be an >>>>> interesting one. >>>>> >>>>> don't know if I'm doing something wrong but I would appreciate any >>>>> help! >>>>> >>>>> What I'm doing is: >>>>> - starting a test with spring (@JooqTest) + @Testcontainers >>>>> - jooq (for now) is using a real oracle database so let's call it "DSL" >>>>> - I'm creating a postgres container with testcontainers and creating a >>>>> DSLContext >>>>> with the jdbc url etc, let's call it postgresDsl >>>>> >>>>> so when the start up is ready I'm running: >>>>> >>>>> final Meta oracleMeta = dsl.meta(DefaultSchema.DEFAULT_SCHEMA); >>>>> final DDLExportConfiguration configuration = new >>>>> DDLExportConfiguration(); >>>>> final Queries ddl = oracleMeta.ddl(configuration); >>>>> postgresDsl.meta().apply(ddl); >>>>> >>>>> >>>>> the apply method files miserably ( same thing when trying: >>>>> postgresDsl.meta().migrateTo(oracleMeta); >>>>> >>>>> some errors: >>>>> >>>>> org.jooq.impl.DDL : Cannot parse view source >>>>> (to skip parsing, use Settings.parseMetaViewSources): CREATE VIEW >>>>> "pg_timezone_abbrevs" AS SELECT abbrev, >>>>> utc_offset, >>>>> is_dst >>>>> FROM pg_timezone_abbrevs() pg_timezone_abbrevs(abbrev, utc_offset, >>>>> is_dst); >>>>> >>>>> org.jooq.impl.ParserException: Keyword 'SELECT' expected: [4:29] >>>>> ...tc_offset, >>>>> is_dst >>>>> FROM pg_timezone_abbrevs([*]) pg_timezone_abbrevs(abbrev, >>>>> utc_offset, is_dst); >>>>> >>>>> -- >>>>> 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 jooq-user+...@googlegroups.com. >>>>> To view this discussion visit >>>>> https://groups.google.com/d/msgid/jooq-user/9c35d75c-aa4a-4814-b7f6-3e6df29a14dfn%40googlegroups.com >>>>> <https://groups.google.com/d/msgid/jooq-user/9c35d75c-aa4a-4814-b7f6-3e6df29a14dfn%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>> . >>>>> >>>> -- >>> 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 jooq-user+...@googlegroups.com. >>> >> To view this discussion visit >>> https://groups.google.com/d/msgid/jooq-user/41c74398-6793-43e8-9599-12563a922598n%40googlegroups.com >>> <https://groups.google.com/d/msgid/jooq-user/41c74398-6793-43e8-9599-12563a922598n%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >> -- > 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 jooq-user+unsubscr...@googlegroups.com. > To view this discussion visit > https://groups.google.com/d/msgid/jooq-user/3bcc93a2-f2c8-4dcb-bbe0-eb8a5fd5fb11n%40googlegroups.com > <https://groups.google.com/d/msgid/jooq-user/3bcc93a2-f2c8-4dcb-bbe0-eb8a5fd5fb11n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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 jooq-user+unsubscr...@googlegroups.com. To view this discussion visit https://groups.google.com/d/msgid/jooq-user/CAB4ELO5DBF4VxooxZi%2BiByo7u9wQtG-fwbkWj%2BTE2b_Zgyhnxw%40mail.gmail.com.
