Revision 12247
Added by Aaron Marcuse-Kubitza almost 11 years ago
trunk/schemas/util.sql | ||
---|---|---|
1973 | 1973 |
|
1974 | 1974 |
|
1975 | 1975 |
-- |
1976 |
-- Name: rematerialize_view(text, regclass); Type: FUNCTION; Schema: util; Owner: - |
|
1977 |
-- |
|
1978 |
|
|
1979 |
CREATE FUNCTION rematerialize_view(table_ text, view_ regclass) RETURNS void |
|
1980 |
LANGUAGE sql |
|
1981 |
AS $_$ |
|
1982 |
SELECT util.drop_table($1); |
|
1983 |
SELECT util.materialize_view($1, $2); |
|
1984 |
$_$; |
|
1985 |
|
|
1986 |
|
|
1987 |
-- |
|
1988 |
-- Name: FUNCTION rematerialize_view(table_ text, view_ regclass); Type: COMMENT; Schema: util; Owner: - |
|
1989 |
-- |
|
1990 |
|
|
1991 |
COMMENT ON FUNCTION rematerialize_view(table_ text, view_ regclass) IS ' |
|
1992 |
idempotent, but repeats action each time |
|
1993 |
'; |
|
1994 |
|
|
1995 |
|
|
1996 |
-- |
|
1976 | 1997 |
-- Name: rename_cols(regclass, anyelement); Type: FUNCTION; Schema: util; Owner: - |
1977 | 1998 |
-- |
1978 | 1999 |
|
Also available in: Unified diff
schemas/util.sql: added rematerialize_view()