Two very minor points with the new alter table (not sure if they are
even bugs are have already been addressed).
1. alter table alter type on a clustered index seems to drop the cluster
(by design)?
2. alter table cluster on seems to give a strange error message of the
index name is really the name of a table.
Ex:
alter table test cluster on test;
returns:
ERROR: cache lookup failed for index 19013
Merlin
Log:
test=# create table test (id int);
CREATE TABLE
test=# create index test_id_idx on test(id);
CREATE INDEX
test=# alter table test cluster on test;
ERROR: cache lookup failed for index 19046
test=# alter table test cluster on test_id_idx;
ALTER TABLE
test=# \d test Table "public.test"Column | Type | Modifiers
--------+---------+-----------id | integer |
Indexes: "test_id_idx" btree (id) CLUSTER
test=# alter table test alter id type bigint;
ALTER TABLE
test=# \d test Table "public.test"Column | Type | Modifiers
--------+--------+-----------id | bigint |
Indexes: "test_id_idx" btree (id)
test=#
