Revision 14314
Added by Aaron Marcuse-Kubitza over 10 years ago
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
schemas/util.sql: added derived_cols_repopulate()