Allow ALTER TABLE .. SET TABLESPACE to be interrupted.

robertmhaas · robertmhaas · commit b525073970c8 · 2010-07-01T14:11:03.000Z
Backpatch to 8.0, where tablespaces were introduced.

Guillaume Lelarge
diff --git a/src/backend/commands/tablecmds.c b/src/backend/commands/tablecmds.c
@@ -8,7 +8,7 @@
  *
  *
  * IDENTIFICATION
- *	  $PostgreSQL: pgsql/src/backend/commands/tablecmds.c,v 1.174.2.9 2009/12/09 21:58:42 tgl Exp $
+ *	  $PostgreSQL: pgsql/src/backend/commands/tablecmds.c,v 1.174.2.10 2010/07/01 14:11:03 rhaas Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -5863,6 +5863,9 @@ copy_relation_data(Relation rel, SMgrRelation dst)
 
 	for (blkno = 0; blkno < nblocks; blkno++)
 	{
+		/* If we got a cancel signal during the copy of the data, quit */
+		CHECK_FOR_INTERRUPTS();
+
 		smgrread(src, blkno, buf);
 
 		/* XLOG stuff */

Original file line number	Diff line number	Diff line change
`@@ -8,7 +8,7 @@`
`8`	`8`	`*`
`9`	`9`	`*`
`10`	`10`	`* IDENTIFICATION`
`11`		`- * $PostgreSQL: pgsql/src/backend/commands/tablecmds.c,v 1.174.2.9 2009/12/09 21:58:42 tgl Exp $`
	`11`	`+ * $PostgreSQL: pgsql/src/backend/commands/tablecmds.c,v 1.174.2.10 2010/07/01 14:11:03 rhaas Exp $`
`12`	`12`	`*`
`13`	`13`	`*-------------------------------------------------------------------------`
`14`	`14`	`*/`
`@@ -5863,6 +5863,9 @@ copy_relation_data(Relation rel, SMgrRelation dst)`
`5863`	`5863`
`5864`	`5864`	`for (blkno = 0; blkno < nblocks; blkno++)`
`5865`	`5865`	`{`
	`5866`	`+ /* If we got a cancel signal during the copy of the data, quit */`
	`5867`	`+ CHECK_FOR_INTERRUPTS();`
	`5868`	`+`
`5866`	`5869`	`smgrread(src, blkno, buf);`
`5867`	`5870`
`5868`	`5871`	`/* XLOG stuff */`