config.db_patch_dependencies

↑ config schema

Data-Modifying Triggers: This table has BEFORE ROW trigger(s) that modify row data before write. Values you INSERT or UPDATE may differ from what is actually stored. See the Triggers section below.

Columns

Column Type Nullable Default Notes

db_patch PK

text

No

supersedes

text[]

Yes

deprecates

text[]

Yes

Primary Key

(db_patch)

Indexes

Index Method Definition

db_patch_dependencies_pkey PK

btree

CREATE UNIQUE INDEX db_patch_dependencies_pkey ON config.db_patch_dependencies USING btree (db_patch)

Triggers

Trigger Timing Event Level Function

no_overlapping_deps

BEFORE

INSERT OR UPDATE

ROW

evergreen.array_overlap_check()

no_overlapping_sups

BEFORE

INSERT OR UPDATE

ROW

evergreen.array_overlap_check()

Trigger Bodies

no_overlapping_deps

Function: evergreen.array_overlap_check()
Timing: BEFORE INSERT OR UPDATE ROW

This trigger modifies the row before it is written (returns a modified NEW).

 
DECLARE
    fld     TEXT;
    cnt     INT;
BEGIN
    fld := TG_ARGV[0];
    EXECUTE 'SELECT COUNT(*) FROM '|| TG_TABLE_SCHEMA ||'.'|| TG_TABLE_NAME ||' WHERE '|| fld ||' && ($1).'|| fld INTO cnt USING NEW;
    IF cnt > 0 THEN
        RAISE EXCEPTION 'Cannot insert duplicate array into field % of table %', fld, TG_TABLE_SCHEMA ||'.'|| TG_TABLE_NAME;
    END IF;
    RETURN NEW;
END;

no_overlapping_sups

Function: evergreen.array_overlap_check()
Timing: BEFORE INSERT OR UPDATE ROW

This trigger modifies the row before it is written (returns a modified NEW).

 
DECLARE
    fld     TEXT;
    cnt     INT;
BEGIN
    fld := TG_ARGV[0];
    EXECUTE 'SELECT COUNT(*) FROM '|| TG_TABLE_SCHEMA ||'.'|| TG_TABLE_NAME ||' WHERE '|| fld ||' && ($1).'|| fld INTO cnt USING NEW;
    IF cnt > 0 THEN
        RAISE EXCEPTION 'Cannot insert duplicate array into field % of table %', fld, TG_TABLE_SCHEMA ||'.'|| TG_TABLE_NAME;
    END IF;
    RETURN NEW;
END;
Previous
Next