Commit6cfa6cb

committed

Fix CLUSTER.

1 parente6c714b commit6cfa6cbCopy full SHA for 6cfa6cb

File tree

+10

-2

lines changed

+10

-2

lines changed

Lines changed: 4 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -14,7 +14,7 @@`
`14`	`14`	`*`
`15`	`15`	`*`
`16`	`16`	`* IDENTIFICATION`
`17`		`- * $Header: /cvsroot/pgsql/src/backend/commands/cluster.c,v 1.21 1998/01/05 16:38:42 momjian Exp $`
	`17`	`+ * $Header: /cvsroot/pgsql/src/backend/commands/cluster.c,v 1.22 1998/01/10 05:19:03 momjian Exp $`
`18`	`18`	`*`
`19`	`19`	`*-------------------------------------------------------------------------`
`20`	`20`	`*/`
`@@ -177,6 +177,9 @@ cluster(char oldrelname[], char oldindexname[])`
`177`	`177`	`/* Destroy old heap (along with its index) and rename new. */`
`178`	`178`	`heap_destroy_with_catalog(oldrelname);`
`179`	`179`
	`180`	`+CommitTransactionCommand();`
	`181`	`+StartTransactionCommand();`
	`182`	`+`
`180`	`183`	`renamerel(NewHeapName,saveoldrelname);`
`181`	`184`	`TypeRename(NewHeapName,saveoldrelname);`
`182`	`185`

Lines changed: 5 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -1,6 +1,6 @@`
`1`	`1`	`.\" This is --nroff--`
`2`	`2`	`.\" XXX standard disclaimer belongs here....`
`3`		`-.\" $Header: /cvsroot/pgsql/src/man/Attic/cluster.l,v 1.2 1996/12/11 00:27:07 momjian Exp $`
	`3`	`+.\" $Header: /cvsroot/pgsql/src/man/Attic/cluster.l,v 1.3 1998/01/10 05:19:14 momjian Exp $`
`4`	`4`	`.TH CLUSTER SQL 01/23/93 PostgreSQL PostgreSQL`
`5`	`5`	`.SH NAME`
`6`	`6`	`cluster\(em give storage clustering advice to Postgres`
`@@ -21,6 +21,10 @@ information. The clustering is static. In other words, if the class is`
`21`	`21`	`updated, it may become unclustered. No attempt is made to keep new`
`22`	`22`	`instances or updated tuples clustered. If desired, the user can`
`23`	`23`	`recluster manually by issuing the command again.`
	`24`	`+.PP`
	`25`	`+The table is actually copied to temporary table in index order,`
	`26`	`+then renamed back to the original name. For this reason, all`
	`27`	`+grant permissions and other indexes are lost when cluster is performed.`
`24`	`28`	`.SH EXAMPLE`
`25`	`29`	`.nf`
`26`	`30`	`/*`

Lines changed: 1 addition & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -8,3 +8,4 @@ doc/TODO`
`8`	`8`	`doc/bug.template`
`9`	`9`	`make new /mirgration file`
`10`	`10`	`update include/version.h after release`
	`11`	`+update backend/parser/scan.l for non-flex sites`

Comments

(0)