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])