Applied. Sorry I missed this one. I did a clean compile and initdb for testing, but forgot regression.
--------------------------------------------------------------------------- Neil Conway wrote: > Seems like a result of Alverro's cluster patch -- looks like the patch > didn't updated the expected results for the regression tests > fully. Diffs below. > > Cheers, > > Neil > > -- > Neil Conway <[EMAIL PROTECTED]> || PGP Key ID: DB3C29FC > > *** ./expected/cluster.out Fri Nov 15 12:35:36 2002 > --- ./results/cluster.out Fri Nov 15 12:39:33 2002 > *************** > *** 302,307 **** > --- 302,310 ---- > INSERT INTO clstr_2 VALUES (1); > INSERT INTO clstr_3 VALUES (2); > INSERT INTO clstr_3 VALUES (1); > + -- "CLUSTER <tablename>" on a table that hasn't been clustered > + CLUSTER clstr_2; > + ERROR: CLUSTER: No previously clustered index found on table clstr_2 > CLUSTER clstr_1_pkey ON clstr_1; > CLUSTER clstr_2_pkey ON clstr_2; > SELECT * FROM clstr_1 UNION ALL > *************** > *** 344,349 **** > --- 347,364 ---- > 1 > (6 rows) > > + -- cluster a single table using the indisclustered bit previously set > + DELETE FROM clstr_1; > + INSERT INTO clstr_1 VALUES (2); > + INSERT INTO clstr_1 VALUES (1); > + CLUSTER clstr_1; > + SELECT * FROM clstr_1; > + a > + --- > + 1 > + 2 > + (2 rows) > + > -- clean up > \c - > DROP TABLE clstr_1; > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
