Reading the documentation on CLUSTER I see that
"all grant permissions and other indexes are lost when clustering is
performed."
What does this really mean? I understand that all indexes and
permissions are gone, but are there other impacts as well?
Seems so to me that this also affects columns of type SERIAL and
columns that defaults to a nextval('sequence'):
--- X ---
[PostgreSQL 6.5.3 on i386-unknown-freebsd3.1, compiled by gcc 2.7.2.1]
...
test=> create table foo (id serial,name text);
NOTICE: CREATE TABLE will create implicit sequence 'foo_id_seq' for SERIAL column 'foo.id'
NOTICE: CREATE TABLE/UNIQUE will create implicit index 'foo_id_key' for table 'foo'
CREATE
test=> insert into foo(name) values('blah');
INSERT 25021983 1
test=> insert into foo(name) values('bleh');
INSERT 25021984 1
test=> insert into foo(name) values('bloh');
INSERT 25021985 1
test=> cluster foo_id_key on foo;
CLUSTER
test=> insert into foo(name) values('bluh');
INSERT 25021999 1
test=> select * from foo;
id|name
--+----
1|blah
2|bleh
3|bloh
|bluh
--- X ---
Grateful for explanations [and|or] workarounds !
--
Mattias Norlander
mattias@umc.se