Revision 14083
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 3766 | 3766 |
CREATE FUNCTION rematerialize_view(table_esc text, view_ regclass) RETURNS void |
| 3767 | 3767 |
LANGUAGE sql |
| 3768 | 3768 |
AS $_$ |
| 3769 |
SELECT util.drop_table($1); |
|
| 3770 |
SELECT util.materialize_view($1, $2); |
|
| 3769 |
SELECT util.recreate($$ |
|
| 3770 |
SELECT util.drop_table($$||util.quote_typed($1)||$$); |
|
| 3771 |
SELECT util.materialize_view($$||util.quote_typed($1)||$$, $$|| |
|
| 3772 |
util.quote_typed($2)||$$); |
|
| 3773 |
$$); |
|
| 3771 | 3774 |
$_$; |
| 3772 | 3775 |
|
| 3773 | 3776 |
|
Also available in: Unified diff
bugfix: schemas/util.sql: rematerialize_view(): also need to handle the target table's dependent views