Cluster and primary key - Mailing list pgsql-sql

From mikael.kjellstrom@_no_spam_flygtaxi.se (Mikael Kjellström)
Subject Cluster and primary key
Date
Msg-id Xns90B7643CE71ADmikaelkjellstromnosp@206.221.255.129
Whole thread Raw
Responses Re: Cluster and primary key
List pgsql-sql
I can't find a way to cluster a table on another index and keep it's 
primary key.

When I define the table the primary key is created, but it's dropped when I 
cluster the table on another index.

I've tried "alter table add constraint", but that's not supported for 
primary keys.

I'm running 7.1.release4 on Debian Woody.



pgsql-sql by date:

Previous
From: Andrzej Roszkowski
Date:
Subject: PL/PGSQL
Next
From: Hans-Jürgen Schönig
Date:
Subject: Re: Distinct Values