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=#
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
