From 3b33bf7f46e336739d1d579b31cf20b6fa9c7a64 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Sat, 10 Nov 2007 14:36:44 +0000 Subject: [PATCH] Reduce error level of ROLLBACK outside a transaction from WARNING to NOTICE. --- src/backend/access/transam/xact.c | 2 +- src/test/regress/expected/errors.out | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/src/backend/access/transam/xact.c b/src/backend/access/transam/xact.c index 0418edcd26..c7485e350e 100644 --- a/src/backend/access/transam/xact.c +++ b/src/backend/access/transam/xact.c @@ -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 index ba5ecedc0a..257722e94a 100644 --- 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 -- 2.39.5