Bucardo

Last updated: 2020-02-28

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](/Bucardo/object_types/goat)) REFERENCES [bucardo.goat](/Bucardo/schema/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](/Bucardo/object_types/goat), trigger_type)

Bucardo.org is hosted and supported by End Point Dev

End Point Dev logo

Need assistance with Bucardo?

End Point Dev offers professional support for Bucardo, as well as specializing in developing, designing, and marketing effective websites. Since 1995, our diverse team of developers has shown that End Point can handle your organization’s greatest web and database challenges.