Bucardo/tables/bucardo.bucardo custom trigger

From Bucardo

Table: bucardo.bucardo_custom_trigger

Used to override the default bucardo_add_delta trigger on a per-table basis

Column	Type	Notes
id	INTEGER	NOT NULL DEFAULT nextval('bucardo_custom_trigger_id_seq')
goat	INTEGER	NOT NULL
trigger_name	TEXT	NOT NULL
trigger_type	TEXT	NOT NULL
trigger_language	TEXT	NOT NULL DEFAULT 'plpgsql'
trigger_body	TEXT	NOT NULL
trigger_level	TEXT	NOT NULL
status	TEXT	NOT NULL DEFAULT 'active'
cdate	TIMESTAMPTZ	NOT NULL DEFAULT now()

Constraint	Definition
bucardo_custom_trigger_id_pk	PRIMARY KEY (id)
bucardo_custom_trigger_goat_fk	FOREIGN KEY (goat) REFERENCES bucardo.goat(id) ON DELETE CASCADE
type_is_delta_or_trigger	CHECK (trigger_type IN ('delta', 'triggerkick'))
level_is_row_statement	CHECK (trigger_level IN ('ROW', 'STATEMENT'))

Index	Unique?	Definition
bucardo_custom_trigger_goat_type_unique	Yes	(goat, trigger_type)