CLUSTER.

From: Dariusz Pietrzak <dariush(at)ajax(dot)umcs(dot)lublin(dot)pl>
To: pgsql-general(at)postgresql(dot)org
Subject: CLUSTER.
Date: 2001-06-15 14:59:23
Message-ID: Pine.LNX.4.10.10106151656190.24440-100000@ajax.umcs.lublin.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Matteo Centenaro 2001-06-15 15:10:34 Re: Insert and limit
Previous Message Alex Pilosov 2001-06-15 14:59:11 Re: OT: Apache::Session::DBI vs postgresql? --help