Re: CLUSTER in PgAdmin

From: Thom Brown <thom(at)linux(dot)com>
To: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Cc: pgadmin-support <pgadmin-support(at)postgresql(dot)org>
Subject: Re: CLUSTER in PgAdmin
Date: 2011-07-02 23:45:56
Message-ID: CAA-aLv7NNF2grJvfQhR20NarddT5EZA_DzUFdT12UREYobdsxQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

On 2 July 2011 23:57, Thom Brown <thom(at)linux(dot)com> wrote:
> On 2 July 2011 13:11, Guillaume Lelarge <guillaume(at)lelarge(dot)info> wrote:
>> On Sat, 2011-07-02 at 10:23 +0100, Thom Brown wrote:
>>> Hi
>>>
>>> How does one run CLUSTER on a table using the PgAdmin GUI? (assuming I
>>> have an index I selected "clustered" on)
>>>
>>
>> AFAICT, you can't. You can add the cluster bit on an index, but that's
>> all you can do. Seems we missed something that would be interesting to
>> add in 1.16.
>
> Okay, here's a patch for it. (see attached)  Not entirely confident on
> the elegance of the code, but had a stab at it.

Oh, just discovered you can cluster on a primary key or a unique
constraint, so modified it to support those too. (revised patch
attached)

--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Attachment Content-Type Size
cluster_feature_v2.patch text/x-patch 2.0 KB

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Guillaume Lelarge 2011-07-03 09:06:03 Re: CLUSTER in PgAdmin
Previous Message Thom Brown 2011-07-02 22:57:15 Re: CLUSTER in PgAdmin