Cluster and primary key

From: mikael(dot)kjellstrom(at)_no_spam_flygtaxi(dot)se (Mikael Kjellstrm)
To: pgsql-sql(at)postgresql(dot)org
Subject: Cluster and primary key
Date: 2001-06-05 07:51:11
Message-ID: Xns90B7643CE71ADmikaelkjellstromnosp@206.221.255.129
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Mikael Kjellstrm 2001-06-05 08:23:40 Foreign key to base table with rows in inherited tables
Previous Message Andrzej Roszkowski 2001-06-05 06:18:03 PL/PGSQL