ddls.postgres.ddl Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of dlock-jdbc Show documentation

There is a newer version: 0.2.1

-- This needs to be executed before the ddl
-- CREATE EXTENSION btree_gist;

CREATE TABLE public.lock (
  id          SERIAL PRIMARY KEY,
  name        TEXT,
  owner       TEXT,
  locked_at   TIMESTAMP,
  locked_till TIMESTAMP,
  CHECK ( locked_at < locked_till ),
  CONSTRAINT overlapping_times EXCLUDE USING GIST (
    name WITH =,
    tsrange(locked_at, locked_till) WITH &&
  )
);