diff options
| author | Bruce Momjian <bruce@momjian.us> | 2004-08-28 22:06:04 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2004-08-28 22:06:04 +0000 |
| commit | 5395aed9d55e8da3e87818932b58e3d2b97681ce (patch) | |
| tree | 5edf295b691f7057dc39cdb1d59f0cde66bbb957 /src | |
| parent | f78ecbf20ec473545f383179b789bce5a10d1757 (diff) | |
| download | postgresql-5395aed9d55e8da3e87818932b58e3d2b97681ce.tar.gz postgresql-5395aed9d55e8da3e87818932b58e3d2b97681ce.zip | |
Add regression tests for ALTER INDEX.
Gavin Sherry
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/alter_table.out | 4 | ||||
| -rw-r--r-- | src/test/regress/sql/alter_table.sql | 4 |
2 files changed, 4 insertions, 4 deletions
diff --git a/src/test/regress/expected/alter_table.out b/src/test/regress/expected/alter_table.out index a8f81624fb2..787340ddb57 100644 --- a/src/test/regress/expected/alter_table.out +++ b/src/test/regress/expected/alter_table.out @@ -126,8 +126,8 @@ DROP TABLE tmp_new; DROP TABLE tmp_new2; -- ALTER TABLE ... RENAME on non-table relations -- renaming indexes (FIXME: this should probably test the index's functionality) -ALTER TABLE onek_unique1 RENAME TO tmp_onek_unique1; -ALTER TABLE tmp_onek_unique1 RENAME TO onek_unique1; +ALTER INDEX onek_unique1 RENAME TO tmp_onek_unique1; +ALTER INDEX tmp_onek_unique1 RENAME TO onek_unique1; -- renaming views CREATE VIEW tmp_view (unique1) AS SELECT unique1 FROM tenk1; ALTER TABLE tmp_view RENAME TO tmp_view_new; diff --git a/src/test/regress/sql/alter_table.sql b/src/test/regress/sql/alter_table.sql index 6077788583c..6b94e14ec85 100644 --- a/src/test/regress/sql/alter_table.sql +++ b/src/test/regress/sql/alter_table.sql @@ -166,8 +166,8 @@ DROP TABLE tmp_new2; -- ALTER TABLE ... RENAME on non-table relations -- renaming indexes (FIXME: this should probably test the index's functionality) -ALTER TABLE onek_unique1 RENAME TO tmp_onek_unique1; -ALTER TABLE tmp_onek_unique1 RENAME TO onek_unique1; +ALTER INDEX onek_unique1 RENAME TO tmp_onek_unique1; +ALTER INDEX tmp_onek_unique1 RENAME TO onek_unique1; -- renaming views CREATE VIEW tmp_view (unique1) AS SELECT unique1 FROM tenk1; ALTER TABLE tmp_view RENAME TO tmp_view_new; |