Revision 14370
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 2365 | 2365 |
CREATE FUNCTION drop_column(col col, force boolean DEFAULT false) RETURNS void |
| 2366 | 2366 |
LANGUAGE sql |
| 2367 | 2367 |
AS $_$ |
| 2368 |
SELECT util.eval($$ALTER TABLE $$||$1.table_||$$ DROP COLUMN IF EXISTS $$||
|
|
| 2368 |
SELECT util.recreate($$ALTER TABLE $$||$1.table_||$$ DROP COLUMN IF EXISTS $$||
|
|
| 2369 | 2369 |
quote_ident($1.name)||util._if($2, $$ CASCADE$$, ''::text)) |
| 2370 | 2370 |
$_$; |
| 2371 | 2371 |
|
Also available in: Unified diff
fix: schemas/util.sql: drop_column(): also need to recreate dependent views