From 26993b2918551552b74b559ab410228dc0670cd5 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Fri, 30 Aug 2002 22:18:07 +0000 Subject: AUTOCOMMIT mode is now an available backend GUC variable; setting it to false provides more SQL-spec-compliant behavior than we had before. I am not sure that setting it false is actually a good idea yet; there is a lot of client-side code that will probably be broken by turning autocommit off. But it's a start. Loosely based on a patch by David Van Wie. --- src/backend/commands/async.c | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) (limited to 'src/backend/commands/async.c') diff --git a/src/backend/commands/async.c b/src/backend/commands/async.c index 4c7c5f21102..97e1dc17ae2 100644 --- a/src/backend/commands/async.c +++ b/src/backend/commands/async.c @@ -7,7 +7,7 @@ * Portions Copyright (c) 1994, Regents of the University of California * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/commands/async.c,v 1.88 2002/08/05 03:29:16 tgl Exp $ + * $Header: /cvsroot/pgsql/src/backend/commands/async.c,v 1.89 2002/08/30 22:18:05 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -400,9 +400,9 @@ Async_UnlistenOnExit(void) */ AbortOutOfAnyTransaction(); /* Now we can do the unlisten */ - StartTransactionCommand(); + StartTransactionCommand(true); Async_UnlistenAll(); - CommitTransactionCommand(); + CommitTransactionCommand(true); } /* @@ -749,7 +749,7 @@ ProcessIncomingNotify(void) notifyInterruptOccurred = 0; - StartTransactionCommand(); + StartTransactionCommand(true); lRel = heap_openr(ListenerRelationName, AccessExclusiveLock); tdesc = RelationGetDescr(lRel); @@ -803,7 +803,7 @@ ProcessIncomingNotify(void) */ heap_close(lRel, NoLock); - CommitTransactionCommand(); + CommitTransactionCommand(true); /* * Must flush the notify messages to ensure frontend gets them -- cgit v1.2.3