Re: ALTER TABLE TODO items
От | Merlin Moncure |
---|---|
Тема | Re: ALTER TABLE TODO items |
Дата | |
Msg-id | 6EE64EF3AB31D5448D0007DD34EEB34101AE08@Herge.rcsinc.local обсуждение исходный текст |
Ответ на | ALTER TABLE TODO items (Bruce Momjian <pgman@candle.pha.pa.us>) |
Ответы |
Re: ALTER TABLE TODO items
Re: ALTER TABLE TODO items |
Список | pgsql-hackers |
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=#
В списке pgsql-hackers по дате отправления: