Re: [HACKERS] ALTER TABLE / CLUSTER ON

2003-03-21 Thread Alvaro Herrera
On Fri, Mar 21, 2003 at 11:54:24AM +0800, Christopher Kings-Lynne wrote: I just managed to break the CLUSTER ON patch: Damn... I dunno how I managed to miss this. Please apply the attached patch. -- Alvaro Herrera (alvherre[a]dcc.uchile.cl) Licensee shall have no right to use the Licensed

Re: [HACKERS] ALTER TABLE / CLUSTER ON

2003-03-21 Thread Alvaro Herrera
On Fri, Mar 21, 2003 at 11:21:16AM +0800, Christopher Kings-Lynne wrote: Does the new ALTER TABLE / CLUSTER ON syntax support the ONLY modifier - it isn't documented if it is?? I guess it's not really relevant is it? Oh, sorry, the command does not recurse. Should it? The whole CLUSTER thing

Re: [HACKERS] ALTER TABLE / CLUSTER ON

2003-03-21 Thread Christopher Kings-Lynne
How can it recurse, actually - there won't be an index with the same name in the subtable? On Fri, 21 Mar 2003, Alvaro Herrera wrote: On Fri, Mar 21, 2003 at 11:21:16AM +0800, Christopher Kings-Lynne wrote: Does the new ALTER TABLE / CLUSTER ON syntax support the ONLY modifier - it isn't

Re: [HACKERS] ALTER TABLE / CLUSTER ON

2003-03-20 Thread Christopher Kings-Lynne
I just managed to break the CLUSTER ON patch: test=# create table test (a int4 primary key, b int4 unique, c int4); NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'test_pkey' for table 'test' NOTICE: CREATE TABLE / UNIQUE will create implicit index 'test_b_key' for table 'test'