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/CAB4ELO4Zeqbu-Ei68V00V4c4nrTLSHo11XQKAOmfEoveUuHKFA%40mail.gmail.com.
