Re: [ADMIN] CLUSTER and SERAIL type

So it seems it drops column defaults too. Yikes. I will add to manual
page. Peter E. any chance of hacking this as part of DROP COLUMN?

> 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
>
>
>
>
>
> ************
>
>

--
Bruce Momjian | http://www.op.net/~candle
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026