Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group