Mercurial > gemma

comparison schema/gemma.sql @ 1354:1000e0e71d5a

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added missing rights and fixed trigger function.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Mon, 26 Nov 2018 15:21:34 +0100
parents 5bb1e3c1f364
children ac6aa40005b4
comparison
equal deleted inserted replaced
1353:d524d6f54f87 1354:1000e0e71d5a
584 584
585 CREATE FUNCTION waterway.del_import() RETURNS trigger AS 585 CREATE FUNCTION waterway.del_import() RETURNS trigger AS
586 $$ 586 $$
587 BEGIN 587 BEGIN
588 EXECUTE format('DELETE FROM %s WHERE id = $1', OLD.relation) USING OLD.key; 588 EXECUTE format('DELETE FROM %s WHERE id = $1', OLD.relation) USING OLD.key;
589 RETURN NULL;
589 END; 590 END;
590 $$ 591 $$
591 LANGUAGE plpgsql; 592 LANGUAGE plpgsql;
592 593
593 CREATE TRIGGER delete_import AFTER DELETE ON waterway.track_imports 594 CREATE TRIGGER delete_import AFTER DELETE ON waterway.track_imports