CLUSTER and SERAIL type

From: Mattias Norlander <mattias(at)umc(dot)se>
To: pgsql-admin(at)postgreSQL(dot)org
Subject: CLUSTER and SERAIL type
Date: 2000-02-11 09:02:52
Message-ID: 8666vw862r.fsf@umc.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)umc(dot)se

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message John Uhlig 2000-02-11 14:11:25 Re: [ADMIN] problem starting 2 postmasters on sun solaris2.6
Previous Message John Uhlig 2000-02-11 07:49:46 problem starting 2 postmasters on sun solaris2.6