Change COMMIT back to the old behavior of emitting command tag COMMIT,

tglsfdc · tglsfdc · commit 88868d4fbcef · 2004-10-30T20:44:43.000Z
not ROLLBACK, for the case of COMMIT outside a transaction block.
Alvaro Herrera
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.193 2004/10/29 22:19:53 tgl Exp $
+ *	  $PostgreSQL: pgsql/src/backend/access/transam/xact.c,v 1.194 2004/10/30 20:44:43 tgl Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -2538,16 +2538,16 @@ EndTransactionBlock(void)
 			break;
 
 			/*
-			 * here, the user issued COMMIT when not inside a transaction.
-			 * Issue a WARNING and go to abort state.  The upcoming call
-			 * to CommitTransactionCommand() will then put us back into
-			 * the default state.
+			 * The user issued COMMIT when not inside a transaction.  Issue a
+			 * WARNING, staying in TBLOCK_STARTED state.  The upcoming call to
+			 * CommitTransactionCommand() will then close the transaction and
+			 * put us back into the default state.
 			 */
 		case TBLOCK_STARTED:
 			ereport(WARNING,
 					(errcode(ERRCODE_NO_ACTIVE_SQL_TRANSACTION),
 					 errmsg("there is no transaction in progress")));
-			s->blockState = TBLOCK_ABORT_PENDING;
+			result = true;
 			break;
 
 			/* These cases are invalid. */
