The versions I'm using, as requested: jOOQ: 3.13.5 Java: compiling with jvm_target_version=1.8, and running with Java 11.0.8 Database: PostgreSQL server 10.9 OS: Ubuntu 20.04.1 LTS 64-bit JDBC driver: 'org.postgresql.Driver'
Thanks, Maurizio. On Friday, 30 October 2020 at 17:26:50 UTC+1 [email protected] wrote: > Hi Maurizio, > > Thank you very much for your message. > > Can you please provide a few versions to help reproduce this: > > - jOOQ: > - Java: > - Database (include vendor): > - OS: > - JDBC Driver (include name if inofficial driver): > > Thanks, > Lukas > > On Fri, Oct 30, 2020 at 1:51 PM Maurizio <[email protected]> wrote: > >> Hello, once more. >> >> This is an issue that I had for some time, even if I could work around it. >> In my database, I have a UDT defined as >> >> >> >> >> >> *CREATE TYPE public.arrangement_track_bar_index AS( >> arrangement_track_id uuid, bar_index integer);* >> >> It's used in a table defined as: >> >> >> >> >> >> *CREATE TABLE public.arrangement_version(arrangement_version_id uuid NOT >> NULL,name character varying(128) COLLATE pg_catalog."default" NOT NULL,-- >> HERE IT COMES:* >> >> >> >> >> *composition arrangement_track_bar_index[] NOT NULL,creator_user_id uuid >> NOT NULL,creation_timestamp timestamp with time zone NOT >> NULL,parent_arrangement_version_id uuid,-- etc...* >> *)* >> >> When I fetch a Record, the corresponding field (*composition*) is null. >> I have to create a view where the array is unnested and fetch the elements >> separately from there and then fix the Record manually. >> >> Could you help me to understand what is happening? >> >> I can successfully and correctly perform an insert in the same table >> without data loss. >> >> This issue is unrelated to the one described in my previous message. >> >> Thanks, >> >> Maurizio. >> >> -- >> 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 [email protected]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/jooq-user/e68801b2-f6c7-4cb4-a9f7-f3fbb6a7b977n%40googlegroups.com >> >> <https://groups.google.com/d/msgid/jooq-user/e68801b2-f6c7-4cb4-a9f7-f3fbb6a7b977n%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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/05a19f8c-2d10-4462-81a9-d2d13c4ea361n%40googlegroups.com.
