Allow TRUNCATE foo, foo to succeed, per report from Nikhils.

bmomjian · bmomjian · commit 895a4bccb666 · 2008-07-16T16:54:08.000Z
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.259 2008/06/19 00:46:04 alvherre Exp $
+ *	  $PostgreSQL: pgsql/src/backend/commands/tablecmds.c,v 1.260 2008/07/16 16:54:08 momjian Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -762,6 +762,9 @@ ExecuteTruncate(TruncateStmt *stmt)
 	ResultRelInfo *resultRelInfo;
 	ListCell   *cell;
 
+	/* make list unique */
+	stmt->relations = list_union(NIL, stmt->relations);
+
 	/*
 	 * Open, exclusive-lock, and check all the explicitly-specified relations
 	 */

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.259 2008/06/19 00:46:04 alvherre Exp $`
	`11`	`+ * $PostgreSQL: pgsql/src/backend/commands/tablecmds.c,v 1.260 2008/07/16 16:54:08 momjian Exp $`
`12`	`12`	`*`
`13`	`13`	`*-------------------------------------------------------------------------`
`14`	`14`	`*/`
`@@ -762,6 +762,9 @@ ExecuteTruncate(TruncateStmt *stmt)`
`762`	`762`	`ResultRelInfo *resultRelInfo;`
`763`	`763`	`ListCell *cell;`
`764`	`764`
	`765`	`+ /* make list unique */`
	`766`	`+ stmt->relations = list_union(NIL, stmt->relations);`
	`767`	`+`
`765`	`768`	`/*`
`766`	`769`	`* Open, exclusive-lock, and check all the explicitly-specified relations`
`767`	`770`	`*/`