Can't INSERT/UPDATE/DELETE sequence relation.

vadim4o · vadim4o · commit 41aeed43344d · 1997-04-02T04:04:11.000Z
diff --git a/src/backend/executor/execMain.c b/src/backend/executor/execMain.c
@@ -26,7 +26,7 @@
  *
  *
  * IDENTIFICATION
- *    $Header: /cvsroot/pgsql/src/backend/executor/execMain.c,v 1.11 1997/03/12 20:47:41 scrappy Exp $
+ *    $Header: /cvsroot/pgsql/src/backend/executor/execMain.c,v 1.12 1997/04/02 04:04:11 vadim Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -419,6 +419,10 @@ InitPlan(CmdType operation, Query *parseTree, Plan *plan, EState *estate)
 	resultRelationOid =   rtentry->relid;
 	resultRelationDesc =  heap_open(resultRelationOid);
 	
+	if ( resultRelationDesc->rd_rel->relkind == RELKIND_SEQUENCE )
+	    elog (WARN, "You can't change sequence relation %s",
+			resultRelationDesc->rd_rel->relname.data);
+
 	/* Write-lock the result relation right away: if the relation
 	   is used in a subsequent scan, we won't have to elevate the 
 	   read-lock set by heap_beginscan to a write-lock (needed by 

Original file line number	Diff line number	Diff line change
`@@ -26,7 +26,7 @@`
`26`	`26`	`*`
`27`	`27`	`*`
`28`	`28`	`* IDENTIFICATION`
`29`		`- * $Header: /cvsroot/pgsql/src/backend/executor/execMain.c,v 1.11 1997/03/12 20:47:41 scrappy Exp $`
	`29`	`+ * $Header: /cvsroot/pgsql/src/backend/executor/execMain.c,v 1.12 1997/04/02 04:04:11 vadim Exp $`
`30`	`30`	`*`
`31`	`31`	`*-------------------------------------------------------------------------`
`32`	`32`	`*/`
`@@ -419,6 +419,10 @@ InitPlan(CmdType operation, Query parseTree, Plan plan, EState *estate)`
`419`	`419`	`resultRelationOid = rtentry->relid;`
`420`	`420`	`resultRelationDesc = heap_open(resultRelationOid);`
`421`	`421`
	`422`	`+ if ( resultRelationDesc->rd_rel->relkind == RELKIND_SEQUENCE )`
	`423`	`+ elog (WARN, "You can't change sequence relation %s",`
	`424`	`+ resultRelationDesc->rd_rel->relname.data);`
	`425`	`+`
`422`	`426`	`/* Write-lock the result relation right away: if the relation`
`423`	`427`	`is used in a subsequent scan, we won't have to elevate the`
`424`	`428`	`read-lock set by heap_beginscan to a write-lock (needed by`