I just managed to break the CLUSTER ON patch: test=# create table test (a int4 primary key, b int4 unique, c int4); NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'test_pkey' for table 'test' NOTICE: CREATE TABLE / UNIQUE will create implicit index 'test_b_key' for table 'test' NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'test_pkey' for table 'test' NOTICE: CREATE TABLE / UNIQUE will create implicit index 'test_b_key' for table 'test' CREATE TABLE test=# create index blah on test(c); CREATE INDEX test=# alter table test cluster on a; ERROR: ALTER TABLE: cannot find index "a" for table "test" ERROR: ALTER TABLE: cannot find index "a" for table "test" test=# alter table test cluster on blah; ALTER TABLE test=# alter table only test cluster on blah; ERROR: parser: parse error at or near "cluster" at character 23 ERROR: parser: parse error at or near "cluster" at character 23 test=# alter table test cluster on blah; NOTICE: ALTER TABLE: table "test" is already being clustered on index "blah" WARNING: Cache reference leak: cache pg_index (16), tuple 0 has count 1 NOTICE: ALTER TABLE: table "test" is already being clustered on index "blah" WARNING: Cache reference leak: cache pg_index (16), tuple 0 has count 1 ALTER TABLE
Chris ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
