Reduce error level of ROLLBACK outside a transaction from WARNING to

bmomjian · bmomjian · commit 82748bc253e0 · 2007-11-10T14:36:44.000Z
NOTICE.
diff --git a/src/backend/access/transam/xact.c b/src/backend/access/transam/xact.c
@@ -10,7 +10,7 @@
  *
  *
  * IDENTIFICATION
- *	  $PostgreSQL: pgsql/src/backend/access/transam/xact.c,v 1.251 2007/09/11 03:28:05 tgl Exp $
+ *	  $PostgreSQL: pgsql/src/backend/access/transam/xact.c,v 1.252 2007/11/10 14:36:44 momjian Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -3025,7 +3025,7 @@ UserAbortTransactionBlock(void)
 			 * default state.
 			 */
 		case TBLOCK_STARTED:
-			ereport(WARNING,
+			ereport(NOTICE,
 					(errcode(ERRCODE_NO_ACTIVE_SQL_TRANSACTION),
 					 errmsg("there is no transaction in progress")));
 			s->blockState = TBLOCK_ABORT_PENDING;
diff --git a/src/test/regress/expected/errors.out b/src/test/regress/expected/errors.out
@@ -116,7 +116,7 @@ ERROR:  column "oid" of relation "stud_emp" already exists
  
 -- not in a xact 
 abort;
-WARNING:  there is no transaction in progress
+NOTICE:  there is no transaction in progress
 -- not in a xact 
 end;
 WARNING:  there is no transaction in progress

Original file line number	Diff line number	Diff line change
`@@ -10,7 +10,7 @@`
`10`	`10`	`*`
`11`	`11`	`*`
`12`	`12`	`* IDENTIFICATION`
`13`		`- * $PostgreSQL: pgsql/src/backend/access/transam/xact.c,v 1.251 2007/09/11 03:28:05 tgl Exp $`
	`13`	`+ * $PostgreSQL: pgsql/src/backend/access/transam/xact.c,v 1.252 2007/11/10 14:36:44 momjian Exp $`
`14`	`14`	`*`
`15`	`15`	`*-------------------------------------------------------------------------`
`16`	`16`	`*/`
`@@ -3025,7 +3025,7 @@ UserAbortTransactionBlock(void)`
`3025`	`3025`	`* default state.`
`3026`	`3026`	`*/`
`3027`	`3027`	`case TBLOCK_STARTED:`
`3028`		`- ereport(WARNING,`
	`3028`	`+ ereport(NOTICE,`
`3029`	`3029`	`(errcode(ERRCODE_NO_ACTIVE_SQL_TRANSACTION),`
`3030`	`3030`	`errmsg("there is no transaction in progress")));`
`3031`	`3031`	`s->blockState = TBLOCK_ABORT_PENDING;`