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;


15 Nov 2002 12:43:43 -0500
Neil Conway <neilc@samurai.com>
regression test failure (CVS HEAD)

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, Pennsylvania 19073

Fri, 15 Nov 2002 22:24:44 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: regression test failure (CVS HEAD)