Revision 13467
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 3330 | 3330 |
|
| 3331 | 3331 |
CREATE FUNCTION save_drop_view(view_ text) RETURNS text |
| 3332 | 3332 |
LANGUAGE plpgsql STRICT |
| 3333 |
AS $_$
|
|
| 3333 |
AS $$ |
|
| 3334 | 3334 |
DECLARE |
| 3335 | 3335 |
result text = NULL; |
| 3336 | 3336 |
BEGIN |
| 3337 | 3337 |
BEGIN |
| 3338 | 3338 |
result = util.show_create_view(view_); |
| 3339 |
PERFORM util.eval($$DROP VIEW $$||view_);
|
|
| 3339 |
PERFORM util.drop_view(view_);
|
|
| 3340 | 3340 |
EXCEPTION |
| 3341 | 3341 |
WHEN undefined_table THEN NULL; |
| 3342 | 3342 |
END; |
| 3343 | 3343 |
RETURN result; |
| 3344 | 3344 |
END; |
| 3345 |
$_$;
|
|
| 3345 |
$$; |
|
| 3346 | 3346 |
|
| 3347 | 3347 |
|
| 3348 | 3348 |
-- |
Also available in: Unified diff
schemas/util.sql: save_drop_view(): use util.drop_view()