Revision 12353
Added by Aaron Marcuse-Kubitza over 10 years ago
| util.sql | ||
|---|---|---|
| 1052 | 1052 |
CREATE FUNCTION drop_relation(relation regclass, force boolean DEFAULT false) RETURNS void |
| 1053 | 1053 |
LANGUAGE sql |
| 1054 | 1054 |
AS $_$ |
| 1055 |
SELECT util.drop_relation(util.relation_type($1), $1::text, $2) |
|
| 1055 |
/* use util.qual_name() instead of ::text so that the schema qualifier is always |
|
| 1056 |
included in the debug SQL */ |
|
| 1057 |
SELECT util.drop_relation(util.relation_type($1), util.qual_name($1), $2) |
|
| 1056 | 1058 |
$_$; |
| 1057 | 1059 |
|
| 1058 | 1060 |
|
| ... | ... | |
| 2382 | 2384 |
CREATE FUNCTION rename_relation(from_ regclass, to_ text) RETURNS void |
| 2383 | 2385 |
LANGUAGE sql |
| 2384 | 2386 |
AS $_$ |
| 2385 |
SELECT util.rename_relation($1::text, $2) |
|
| 2387 |
/* use util.qual_name() instead of ::text so that the schema qualifier is always |
|
| 2388 |
included in the debug SQL */ |
|
| 2389 |
SELECT util.rename_relation(util.qual_name($1), $2) |
|
| 2386 | 2390 |
$_$; |
| 2387 | 2391 |
|
| 2388 | 2392 |
|
Also available in: Unified diff
schemas/util.sql: drop_relation(regclass), rename_relation(regclass): use util.qual_name() instead of ::text so that the schema qualifier is always included in the debug SQL