| Revisión | ee364a82c58fcac6702de2cee5b0ca1986382f66 (tree) |
|---|---|
| Tiempo | 2014-11-17 18:05:28 |
| Autor | Kyotaro Horiguchi <horiguchi.kyotaro@lab....> |
| Commiter | Kyotaro Horiguchi |
Fix exception messages.
Exception messages in definitions of dbms_stats.restore(bid, relname,
colname) were incorrect. This causes incomprehensive message like this,
ERROR: too many parameters specified for RAISE
There's no harm other than the bogus message.
ext_scripts/pg_dbms_stats--1.3.4--1.3.5-9.1.sql (diff) ext_scripts/pg_dbms_stats--1.3.4--1.3.5-9.2.sql (diff) ext_scripts/pg_dbms_stats--1.3.4--1.3.5-9.3.sql (diff) ext_scripts/pg_dbms_stats--1.3.4--1.3.5-9.4.sql (diff) ext_scripts/pg_dbms_stats--1.3.5-9.1.sql (diff) ext_scripts/pg_dbms_stats--1.3.5-9.2.sql (diff) ext_scripts/pg_dbms_stats--1.3.5-9.3.sql (diff) ext_scripts/pg_dbms_stats--1.3.5-9.4.sql (diff)| @@ -120,7 +120,7 @@ BEGIN | ||
| 120 | 120 | RAISE EXCEPTION 'column "%" not found in relation %', $3, $2; |
| 121 | 121 | END IF; |
| 122 | 122 | IF NOT EXISTS(SELECT * FROM dbms_stats.column_stats_backup WHERE id <= $1 AND starelid = $2 AND staattnum = set_attnum) THEN |
| 123 | - RAISE EXCEPTION 'statistics of column "%" of relation "%" are not found in any backups before',$3, $2, $1; | |
| 123 | + RAISE EXCEPTION 'statistics of column "%" of relation "%" are not found in any backups before backup id = %',$3, $2, $1; | |
| 124 | 124 | END IF; |
| 125 | 125 | END IF; |
| 126 | 126 | PERFORM * FROM dbms_stats.relation_stats_locked r |
| @@ -112,7 +112,7 @@ BEGIN | ||
| 112 | 112 | RAISE EXCEPTION 'column "%" not found in relation %', $3, $2; |
| 113 | 113 | END IF; |
| 114 | 114 | IF NOT EXISTS(SELECT * FROM dbms_stats.column_stats_backup WHERE id <= $1 AND starelid = $2 AND staattnum = set_attnum) THEN |
| 115 | - RAISE EXCEPTION 'statistics of column "%" of relation "%" are not found in any backups before',$3, $2, $1; | |
| 115 | + RAISE EXCEPTION 'statistics of column "%" of relation "%" are not found in any backups before backup id = %',$3, $2, $1; | |
| 116 | 116 | END IF; |
| 117 | 117 | END IF; |
| 118 | 118 | PERFORM * FROM dbms_stats.relation_stats_locked r |
| @@ -113,7 +113,7 @@ BEGIN | ||
| 113 | 113 | RAISE EXCEPTION 'column "%" not found in relation %', $3, $2; |
| 114 | 114 | END IF; |
| 115 | 115 | IF NOT EXISTS(SELECT * FROM dbms_stats.column_stats_backup WHERE id <= $1 AND starelid = $2 AND staattnum = set_attnum) THEN |
| 116 | - RAISE EXCEPTION 'statistics of column "%" of relation "%" are not found in any backups before',$3, $2, $1; | |
| 116 | + RAISE EXCEPTION 'statistics of column "%" of relation "%" are not found in any backups before backup id = %',$3, $2, $1; | |
| 117 | 117 | END IF; |
| 118 | 118 | END IF; |
| 119 | 119 | PERFORM * FROM dbms_stats.relation_stats_locked r |
| @@ -113,7 +113,7 @@ BEGIN | ||
| 113 | 113 | RAISE EXCEPTION 'column "%" not found in relation %', $3, $2; |
| 114 | 114 | END IF; |
| 115 | 115 | IF NOT EXISTS(SELECT * FROM dbms_stats.column_stats_backup WHERE id <= $1 AND starelid = $2 AND staattnum = set_attnum) THEN |
| 116 | - RAISE EXCEPTION 'statistics of column "%" of relation "%" are not found in any backups before',$3, $2, $1; | |
| 116 | + RAISE EXCEPTION 'statistics of column "%" of relation "%" are not found in any backups before backup id = %',$3, $2, $1; | |
| 117 | 117 | END IF; |
| 118 | 118 | END IF; |
| 119 | 119 | PERFORM * FROM dbms_stats.relation_stats_locked r |
| @@ -492,7 +492,7 @@ BEGIN | ||
| 492 | 492 | RAISE EXCEPTION 'column "%" not found in relation %', $3, $2; |
| 493 | 493 | END IF; |
| 494 | 494 | IF NOT EXISTS(SELECT * FROM dbms_stats.column_stats_backup WHERE id <= $1 AND starelid = $2 AND staattnum = set_attnum) THEN |
| 495 | - RAISE EXCEPTION 'statistics of column "%" of relation "%" are not found in any backups before',$3, $2, $1; | |
| 495 | + RAISE EXCEPTION 'statistics of column "%" of relation "%" are not found in any backups before backup id = %',$3, $2, $1; | |
| 496 | 496 | END IF; |
| 497 | 497 | END IF; |
| 498 | 498 | PERFORM * FROM dbms_stats.relation_stats_locked r |
| @@ -522,7 +522,7 @@ BEGIN | ||
| 522 | 522 | RAISE EXCEPTION 'column "%" not found in relation %', $3, $2; |
| 523 | 523 | END IF; |
| 524 | 524 | IF NOT EXISTS(SELECT * FROM dbms_stats.column_stats_backup WHERE id <= $1 AND starelid = $2 AND staattnum = set_attnum) THEN |
| 525 | - RAISE EXCEPTION 'statistics of column "%" of relation "%" are not found in any backups before',$3, $2, $1; | |
| 525 | + RAISE EXCEPTION 'statistics of column "%" of relation "%" are not found in any backups before backup id = %',$3, $2, $1; | |
| 526 | 526 | END IF; |
| 527 | 527 | END IF; |
| 528 | 528 | PERFORM * FROM dbms_stats.relation_stats_locked r |
| @@ -522,7 +522,7 @@ BEGIN | ||
| 522 | 522 | RAISE EXCEPTION 'column "%" not found in relation %', $3, $2; |
| 523 | 523 | END IF; |
| 524 | 524 | IF NOT EXISTS(SELECT * FROM dbms_stats.column_stats_backup WHERE id <= $1 AND starelid = $2 AND staattnum = set_attnum) THEN |
| 525 | - RAISE EXCEPTION 'statistics of column "%" of relation "%" are not found in any backups before',$3, $2, $1; | |
| 525 | + RAISE EXCEPTION 'statistics of column "%" of relation "%" are not found in any backups before backup id = %',$3, $2, $1; | |
| 526 | 526 | END IF; |
| 527 | 527 | END IF; |
| 528 | 528 | PERFORM * FROM dbms_stats.relation_stats_locked r |
| @@ -522,7 +522,7 @@ BEGIN | ||
| 522 | 522 | RAISE EXCEPTION 'column "%" not found in relation %', $3, $2; |
| 523 | 523 | END IF; |
| 524 | 524 | IF NOT EXISTS(SELECT * FROM dbms_stats.column_stats_backup WHERE id <= $1 AND starelid = $2 AND staattnum = set_attnum) THEN |
| 525 | - RAISE EXCEPTION 'statistics of column "%" of relation "%" are not found in any backups before',$3, $2, $1; | |
| 525 | + RAISE EXCEPTION 'statistics of column "%" of relation "%" are not found in any backups before backup id = %',$3, $2, $1; | |
| 526 | 526 | END IF; |
| 527 | 527 | END IF; |
| 528 | 528 | PERFORM * FROM dbms_stats.relation_stats_locked r |
Fork