/ - Diff - BIEN 3 - NCEAS Projects

« Previous | Next »

Revision 14160

schemas/util.sql: derived_cols_sync(): also create trigger, since this is necessary for a complete sync

         SET search_path TO util
         AS $_$
     DECLARE
     	trigger_name_sql text = table_::text||%'__fill_derived';
     	trigger_func_name_sql text = table_::text||%'__fill_derived';
     	trigger_name text;
     BEGIN
     	PERFORM util.eval($$
     CREATE OR REPLACE FUNCTION $$||trigger_name_sql||$$()
     CREATE OR REPLACE FUNCTION $$||trigger_func_name_sql||$$()
       RETURNS trigger AS
     $BODY1$
     BEGIN
-...
       LANGUAGE plpgsql VOLATILE
       COST 100;
     $$);
     	-- util.name() only works once func exists
     	trigger_name = util.name(trigger_func_name_sql::regproc);
     	PERFORM util.create_if_not_exists($$
     CREATE TRIGGER $$||quote_ident(trigger_name)||$$
       BEFORE INSERT OR UPDATE
       ON $$||table_||$$
       FOR EACH ROW
       EXECUTE PROCEDURE $$||trigger_func_name_sql||$$();$$);
     END;
     $_$;

Also available in: Unified diff