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 <neilc@samurai.com> || 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 pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073