16 lines
382 B
PL/PgSQL
16 lines
382 B
PL/PgSQL
BEGIN;
|
|
|
|
SET ROLE work_role;
|
|
|
|
ALTER TABLE work.agent_dispatch_queue
|
|
ADD COLUMN IF NOT EXISTS retry_limit INTEGER NOT NULL DEFAULT 3;
|
|
|
|
ALTER TABLE work.agent_dispatch_queue
|
|
DROP CONSTRAINT IF EXISTS agent_dispatch_queue_retry_limit_check;
|
|
|
|
ALTER TABLE work.agent_dispatch_queue
|
|
ADD CONSTRAINT agent_dispatch_queue_retry_limit_check CHECK (retry_limit > 0);
|
|
|
|
RESET ROLE;
|
|
COMMIT;
|