Project

General

Profile

« Previous | Next » 

Revision 12247

schemas/util.sql: added rematerialize_view()

View differences:

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