Postgdes exclude constraint causing error

[Leon Meerson]

Hello,

Receiving error on schema compare when target schema contains following table (PG11)

CREATE EXTENSION IF NOT EXISTS "btree_gist";

CREATE TABLE ROOM_SCHEDULE

  (

    SCHEDULE_ID uuid DEFAULT gen_random_uuid() NOT NULL,

    ROOM_ID uuid NOT NULL,

    START_TIME  TIMESTAMPTZ(3) NOT NULL DEFAULT '-infinity',

    END_TIME    TIMESTAMPTZ(3) NOT NULL DEFAULT 'infinity',

    CONSTRAINT CK1_SCHEDULE CHECK (START_TIME < END_TIME),

    CONSTRAINT CK2_SCHEDULE EXCLUDE USING GIST (

        ROOM_ID WITH = ,

        tstzrange  (START_TIME, END_TIME) WITH &&

    ),

  );

[2019-10-05 09:48:46.548] SEVERE: h: Error getting exclude constraints, table=room_schedule

java.lang.NullPointerException

at com.dbsolo.a.h.k(Unknown Source)

at com.dbsolo.a.h.Q(Unknown Source)

at com.dbsolo.a.u.N(Unknown Source)

at com.dbsolo.a._A.ŋ(Unknown Source)

at com.dbsolo.a._A.Y(Unknown Source)

at com.dbsolo.P.UA.D(Unknown Source)

at com.dbsolo.P.UA.B(Unknown Source)

at com.dbsolo.P.UA.A(Unknown Source)

at com.dbsolo.P.r$8.run(Unknown Source)

at com.dbsolo.O.M.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

Thanks,

Leon

[DB Solo Admin]

This should hopefully be fixed now. You can find the latest version at

dbsolo.com/preview

Marko

[Leon Meerson]

Thanks Marko, it works well with latest.