Can't COPY TO sequence relation.

vadim4o · vadim4o · commit e276d8a1a640 · 1997-04-02T03:57:06.000Z
Can't inherits from ...
diff --git a/src/backend/commands/copy.c b/src/backend/commands/copy.c
@@ -6,7 +6,7 @@
  *
  *
  * IDENTIFICATION
- *    $Header: /cvsroot/pgsql/src/backend/commands/copy.c,v 1.22 1997/03/12 20:47:32 scrappy Exp $
+ *    $Header: /cvsroot/pgsql/src/backend/commands/copy.c,v 1.23 1997/04/02 03:57:03 vadim Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -119,6 +119,8 @@ DoCopy(char *relname, bool binary, bool oids, bool from, bool pipe,
         /* Above should not return. */
     else {
         if (from) {  /* copy from file to database */
+	    if ( rel->rd_rel->relkind == RELKIND_SEQUENCE )
+	    	elog (WARN, "You can't change sequence relation %s", relname);
             if (pipe) {
                 if (IsUnderPostmaster) {
                     ReceiveCopyBegin();
diff --git a/src/backend/commands/creatinh.c b/src/backend/commands/creatinh.c
@@ -7,7 +7,7 @@
  *
  *
  * IDENTIFICATION
- *    $Header: /cvsroot/pgsql/src/backend/commands/Attic/creatinh.c,v 1.5 1997/01/10 20:17:11 momjian Exp $
+ *    $Header: /cvsroot/pgsql/src/backend/commands/Attic/creatinh.c,v 1.6 1997/04/02 03:57:06 vadim Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -264,6 +264,11 @@ MergeAttributes(List *schema, List *supers)
 		 "MergeAttr: Can't inherit from non-existent superclass '%s'",
 		 name);
 	}
+	if ( relation->rd_rel->relkind == 'S' )
+	{
+	    elog(WARN, "MergeAttr: Can't inherit from sequence superclass '%s'",
+		 name);
+	}
 	tupleDesc = RelationGetTupleDescriptor(relation);
 	
 	for (attrno = relation->rd_rel->relnatts - 1; attrno >= 0; attrno--) {

Original file line number	Diff line number	Diff line change
`@@ -6,7 +6,7 @@`
`6`	`6`	`*`
`7`	`7`	`*`
`8`	`8`	`* IDENTIFICATION`
`9`		`- * $Header: /cvsroot/pgsql/src/backend/commands/copy.c,v 1.22 1997/03/12 20:47:32 scrappy Exp $`
	`9`	`+ * $Header: /cvsroot/pgsql/src/backend/commands/copy.c,v 1.23 1997/04/02 03:57:03 vadim Exp $`
`10`	`10`	`*`
`11`	`11`	`*-------------------------------------------------------------------------`
`12`	`12`	`*/`
`@@ -119,6 +119,8 @@ DoCopy(char *relname, bool binary, bool oids, bool from, bool pipe,`
`119`	`119`	`/* Above should not return. */`
`120`	`120`	`else {`
`121`	`121`	`if (from) { /* copy from file to database */`
	`122`	`+ if ( rel->rd_rel->relkind == RELKIND_SEQUENCE )`
	`123`	`+ elog (WARN, "You can't change sequence relation %s", relname);`
`122`	`124`	`if (pipe) {`
`123`	`125`	`if (IsUnderPostmaster) {`
`124`	`126`	`ReceiveCopyBegin();`
Original file line number	Diff line number	Diff line change
`@@ -7,7 +7,7 @@`
`7`	`7`	`*`
`8`	`8`	`*`
`9`	`9`	`* IDENTIFICATION`
`10`		`- * $Header: /cvsroot/pgsql/src/backend/commands/Attic/creatinh.c,v 1.5 1997/01/10 20:17:11 momjian Exp $`
	`10`	`+ * $Header: /cvsroot/pgsql/src/backend/commands/Attic/creatinh.c,v 1.6 1997/04/02 03:57:06 vadim Exp $`
`11`	`11`	`*`
`12`	`12`	`*-------------------------------------------------------------------------`
`13`	`13`	`*/`
`@@ -264,6 +264,11 @@ MergeAttributes(List schema, List supers)`
`264`	`264`	`"MergeAttr: Can't inherit from non-existent superclass '%s'",`
`265`	`265`	`name);`
`266`	`266`	`}`
	`267`	`+ if ( relation->rd_rel->relkind == 'S' )`
	`268`	`+ {`
	`269`	`+ elog(WARN, "MergeAttr: Can't inherit from sequence superclass '%s'",`
	`270`	`+ name);`
	`271`	`+ }`
`267`	`272`	`tupleDesc = RelationGetTupleDescriptor(relation);`
`268`	`273`
`269`	`274`	`for (attrno = relation->rd_rel->relnatts - 1; attrno >= 0; attrno--) {`