Revision 14249
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 1965 | 1965 |
SELECT util.check_constraint((def.col, util.derived_col_constraint_expr(def)), |
| 1966 | 1966 |
enabled := util.derived_col_constraint_initially_enabled(def)); |
| 1967 | 1967 |
|
| 1968 |
-- create the trigger |
|
| 1969 |
SELECT util.derived_cols_sync((def).col.table_); |
|
| 1968 |
SELECT util.derived_cols_trigger_update((def).col.table_); |
|
| 1970 | 1969 |
$$; |
| 1971 | 1970 |
|
| 1972 | 1971 |
|
| ... | ... | |
| 2054 | 2053 |
|
| 2055 | 2054 |
|
| 2056 | 2055 |
-- |
| 2057 |
-- Name: derived_cols_sync(regclass); Type: FUNCTION; Schema: util; Owner: -
|
|
| 2056 |
-- Name: derived_cols_trigger_update(regclass); Type: FUNCTION; Schema: util; Owner: -
|
|
| 2058 | 2057 |
-- |
| 2059 | 2058 |
|
| 2060 |
CREATE FUNCTION derived_cols_sync(table_ regclass) RETURNS void
|
|
| 2059 |
CREATE FUNCTION derived_cols_trigger_update(table_ regclass) RETURNS void
|
|
| 2061 | 2060 |
LANGUAGE plpgsql |
| 2062 | 2061 |
SET search_path TO util |
| 2063 | 2062 |
AS $_$ |
Also available in: Unified diff
schemas/util.sql: derived_cols_sync(): renamed to derived_cols_trigger_update() for clarity