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.outFri 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