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 Software for productive or commercial use. (Licencia de StarOffice 6.0 beta)
Index: backend/commands/tablecmds.c =================================================================== RCS file: /projects/cvsroot/pgsql-server/src/backend/commands/tablecmds.c,v retrieving revision 1.69 diff -c -r1.69 tablecmds.c *** backend/commands/tablecmds.c 2003/03/20 18:52:47 1.69 --- backend/commands/tablecmds.c 2003/03/21 15:38:37 *************** *** 3835,3840 **** --- 3835,3841 ---- { elog(NOTICE, "ALTER TABLE: table \"%s\" is already being clustered on index \"%s\"", NameStr(rel->rd_rel->relname), indexName); + ReleaseSysCache(indexTuple); heap_close(rel, AccessExclusiveLock); return; }
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])