16 lines
389 B
PL/PgSQL
16 lines
389 B
PL/PgSQL
-- Add up migration script here
|
|
|
|
CREATE FUNCTION "notify_global_setting_delete" ()
|
|
RETURNS TRIGGER AS $$
|
|
BEGIN
|
|
PERFORM pg_notify('notify_global_setting_change', OLD.name::text);
|
|
RETURN OLD;
|
|
END;
|
|
$$ LANGUAGE PLPGSQL;
|
|
|
|
CREATE OR REPLACE TRIGGER "notify_global_setting_delete"
|
|
AFTER DELETE ON "global_settings"
|
|
FOR EACH ROW
|
|
EXECUTE FUNCTION "notify_global_setting_delete" ();
|
|
|