CLUSTER and SERAIL type
От | Mattias Norlander |
---|---|
Тема | CLUSTER and SERAIL type |
Дата | |
Msg-id | 8666vw862r.fsf@umc.se обсуждение исходный текст |
Ответы |
Re: [ADMIN] CLUSTER and SERAIL type
|
Список | pgsql-admin |
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
В списке pgsql-admin по дате отправления: