diff options
Diffstat (limited to 'src/test/regress/sql/alter_table.sql')
| -rw-r--r-- | src/test/regress/sql/alter_table.sql | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/src/test/regress/sql/alter_table.sql b/src/test/regress/sql/alter_table.sql index bef443b930..5ba66c46e8 100644 --- a/src/test/regress/sql/alter_table.sql +++ b/src/test/regress/sql/alter_table.sql @@ -141,8 +141,12 @@ DROP TABLE tmp; -- -- rename - --- should preserve indices +-- should preserve indices, which we can check by seeing if a SELECT +-- chooses an indexscan; however, in the absence of vacuum statistics +-- it might not. Therefore, vacuum first. -- +VACUUM ANALYZE tenk1; + ALTER TABLE tenk1 RENAME TO ten_k; -- 20 values, sorted |