Index: src/backend/access/transam/xact.c =================================================================== RCS file: /cvsroot/pgsql/src/backend/access/transam/xact.c,v retrieving revision 1.251 diff -c -c -r1.251 xact.c *** src/backend/access/transam/xact.c 11 Sep 2007 03:28:05 -0000 1.251 --- src/backend/access/transam/xact.c 9 Nov 2007 02:45:30 -0000 *************** *** 3025,3031 **** * 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; --- 3025,3031 ---- * default state. */ case TBLOCK_STARTED: ! ereport(NOTICE, (errcode(ERRCODE_NO_ACTIVE_SQL_TRANSACTION), errmsg("there is no transaction in progress"))); s->blockState = TBLOCK_ABORT_PENDING; Index: src/test/regress/expected/errors.out =================================================================== RCS file: /cvsroot/pgsql/src/test/regress/expected/errors.out,v retrieving revision 1.52 diff -c -c -r1.52 errors.out *** src/test/regress/expected/errors.out 15 Apr 2006 17:45:46 -0000 1.52 --- src/test/regress/expected/errors.out 9 Nov 2007 02:45:31 -0000 *************** *** 116,122 **** -- not in a xact abort; ! WARNING: there is no transaction in progress -- not in a xact end; WARNING: there is no transaction in progress --- 116,122 ---- -- not in a xact abort; ! NOTICE: there is no transaction in progress -- not in a xact end; WARNING: there is no transaction in progress