Postgdes exclude constraint causing error

20 views
Skip to first unread message

Leon Meerson

unread,
Oct 5, 2019, 3:04:42 AM10/5/19
to DB Solo
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(3NOT NULL DEFAULT '-infinity',
    END_TIME    TIMESTAMPTZ(3NOT 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

unread,
Oct 6, 2019, 4:45:27 PM10/6/19
to DB Solo
This should hopefully be fixed now. You can find the latest version at


Marko

Leon Meerson

unread,
Oct 10, 2019, 1:26:48 PM10/10/19
to DB Solo
Thanks Marko, it works well with latest.
Reply all
Reply to author
Forward
0 new messages