From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Thom Brown <thom(at)linux(dot)com> |
Cc: | pgadmin-support <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: CLUSTER in PgAdmin |
Date: | 2011-07-03 09:06:03 |
Message-ID: | 1309683963.2037.0.camel@laptop |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
On Sun, 2011-07-03 at 00:45 +0100, Thom Brown wrote:
> 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)
>
Seems good to me. I don't see why you're "not entirely confident on the
elegance of the code". Anyway, commited and pushed.
Thanks for this new patch :)
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2011-07-06 02:13:22 | Re: 1.14b1 doesn't do OSX alerts |
Previous Message | Thom Brown | 2011-07-02 23:45:56 | Re: CLUSTER in PgAdmin |