Turning off cluster patch

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Turning off cluster patch
Date: 2004-04-28 08:08:50
Message-ID: 408F6692.7070305@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Hi,

The attached patch adds a new command:

ALTER TABLE [ONLY] foo SET WITHOUT CLUSTER;

I would probably have preferred the DROP CLUSTER syntax, but it doesn't
seem easy to get working without shift/reduce problems.

It has support for inheritance.

I have also fixed the previously detailed security errors:

* Ownership is now checked
* Can now not cluster system catalogs
* Checks that what you are clustering is actually a table

And it fixes a related bug in the SET WITHOUT OIDS implementation:

* Checks that what you are dropping OIDS from is actually a table

I have included a documentation update and a regression test.

Chris

Attachment Content-Type Size
nocluster.txt text/plain 11.7 KB

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Peter Eisentraut 2004-04-28 15:34:28 Re: FW: Timezone library
Previous Message Tom Lane 2004-04-28 06:31:35 Re: SECURITY DEFINER not being propagated...