Project

General

Profile

« Previous | Next » 

Revision 14314

schemas/util.sql: added derived_cols_repopulate()

View differences:

trunk/schemas/util.sql
2095 2095

  
2096 2096

  
2097 2097
--
2098
-- Name: derived_cols_repopulate(regclass); Type: FUNCTION; Schema: util; Owner: -
2099
--
2100

  
2101
CREATE FUNCTION derived_cols_repopulate(table_ regclass) RETURNS void
2102
    LANGUAGE sql
2103
    AS $$
2104
-- populate derived columns by triggering table__fill_derived()
2105
SELECT util.run_triggers(table_);
2106

  
2107
SELECT util.derived_col_constraints_enable(table_);
2108
$$;
2109

  
2110

  
2111
--
2112
-- Name: FUNCTION derived_cols_repopulate(table_ regclass); Type: COMMENT; Schema: util; Owner: -
2113
--
2114

  
2115
COMMENT ON FUNCTION derived_cols_repopulate(table_ regclass) IS '
2116
idempotent, but repopulates each time
2117
';
2118

  
2119

  
2120
--
2098 2121
-- Name: derived_cols_trigger_update(regclass); Type: FUNCTION; Schema: util; Owner: -
2099 2122
--
2100 2123

  

Also available in: Unified diff