github.com/pf-qiu/concourse/v6@v6.7.3-0.20201207032516-1f455d73275f/atc/db/migration/migrations/1537197729_change_addr_when_running_constraint.up.sql (about)

     1  BEGIN;
     2    ALTER TABLE "workers"
     3    DROP CONSTRAINT IF EXISTS "addr_when_running",
     4    ADD CONSTRAINT "addr_when_running" CHECK (((state <> 'stalled'::worker_state) AND (state <> 'landed'::worker_state) AND ((addr IS NOT NULL) OR (baggageclaim_url IS NOT NULL))) OR (state = 'stalled'::worker_state) OR (state = 'landed'::worker_state)) ;
     5  COMMIT;