Revision 14343
Added by Aaron Marcuse-Kubitza over 10 years ago
trunk/schemas/util.sql | ||
---|---|---|
3501 | 3501 |
|
3502 | 3502 |
|
3503 | 3503 |
-- |
3504 |
-- Name: materialize_view(text, regclass); Type: FUNCTION; Schema: util; Owner: - |
|
3505 |
-- |
|
3506 |
|
|
3507 |
CREATE FUNCTION materialize_view(table_esc text, view_ regclass) RETURNS void |
|
3508 |
LANGUAGE sql |
|
3509 |
AS $_$ |
|
3510 |
SELECT util.create_if_not_exists($$ |
|
3511 |
SELECT util.copy($$||util.quote_typed($2)||$$, $$||util.quote_typed($1)||$$) |
|
3512 |
$$); |
|
3513 |
$_$; |
|
3514 |
|
|
3515 |
|
|
3516 |
-- |
|
3517 |
-- Name: FUNCTION materialize_view(table_esc text, view_ regclass); Type: COMMENT; Schema: util; Owner: - |
|
3518 |
-- |
|
3519 |
|
|
3520 |
COMMENT ON FUNCTION materialize_view(table_esc text, view_ regclass) IS ' |
|
3521 |
idempotent |
|
3522 |
'; |
|
3523 |
|
|
3524 |
|
|
3525 |
-- |
|
3526 | 3504 |
-- Name: mk_const_col(col, anyelement); Type: FUNCTION; Schema: util; Owner: - |
3527 | 3505 |
-- |
3528 | 3506 |
|
Also available in: Unified diff
schemas/util.sql: removed no longer used materialize_view(). use util.copy() instead.