From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Mattias Norlander <mattias(at)umc(dot)se> |
Cc: | pgsql-admin(at)postgreSQL(dot)org |
Subject: | Re: [ADMIN] CLUSTER and SERAIL type |
Date: | 2000-02-11 15:15:24 |
Message-ID: | 200002111515.KAA16529@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Ross J. Reedstrom | 2000-02-11 18:15:30 | Re: [ADMIN] problem starting 2 postmasters on sun solaris2.6 |
Previous Message | Christopher L. Davis | 2000-02-11 15:14:36 | Problems running regression tests on Solaris 7 X86. |