I apologize for my earlier posting. I misinterpreted the term "clustered index".
It's done with CLUSTER indeed. Everything is copied in a temp table which is later renamed to the original table, so
allgrant perimissions and indeces are lost on this table. Also keep in mind that you'll get new OIDs too (if you are
dependingon them)
sorry,
thalis
---------- Forwarded message ----------
Date: Fri, 15 Jun 2001 11:32:53 -0400 (EDT)
From: Thalis A. Kalfigopoulos <thalis@cs.pitt.edu>
To: Dariusz Pietrzak <dariush@ajax.umcs.lublin.pl>
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] CLUSTER.
Read what the command CLUSTER does. Definately not what you think.
You create clustered indeces as you would any index:
create index lala_idx on lala (col1,col2,...);
cheers,
thalis
On Fri, 15 Jun 2001, Dariusz Pietrzak wrote:
> Hello,
> how can I create clustered index on given table?
> When I try "cluster indexname on tablename" it drops and recreates this
> table, effectively dropping all constraints.
> Can I create clustered index without loosing my foreign key etc
> constraints?
>
> --
> Dariusz Pietrzak
> Certified Nobody
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
