Revision 13529
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 1059 | 1059 |
BEGIN |
| 1060 | 1060 |
/* always generate standard exception if exists, even if table definition |
| 1061 | 1061 |
would be invalid (which generates a variety of exceptions) */ |
| 1062 |
IF util.relation_exists(relation) THEN RAISE duplicate_table; END IF; |
|
| 1062 |
IF util.relation_exists(relation) THEN |
|
| 1063 |
PERFORM util.raise('NOTICE', relation||' already exists, skipping');
|
|
| 1064 |
RAISE duplicate_table; |
|
| 1065 |
END IF; |
|
| 1063 | 1066 |
PERFORM util.eval(sql); |
| 1064 | 1067 |
EXCEPTION |
| 1065 | 1068 |
WHEN duplicate_table |
Also available in: Unified diff
schemas/util.sql: create_if_not_exists(): print message if already exists, so the function doesn't inexplicably appear not to have run at all