diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2002-08-30 22:18:07 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2002-08-30 22:18:07 +0000 |
| commit | 26993b2918551552b74b559ab410228dc0670cd5 (patch) | |
| tree | fec5ed9634d32bd3720684da549ee2b9ec59916a /src/backend/commands/indexcmds.c | |
| parent | 549928d99bab650f684fd69dd5ef95553438a957 (diff) | |
| download | postgresql-26993b2918551552b74b559ab410228dc0670cd5.tar.gz postgresql-26993b2918551552b74b559ab410228dc0670cd5.zip | |
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.
Diffstat (limited to 'src/backend/commands/indexcmds.c')
| -rw-r--r-- | src/backend/commands/indexcmds.c | 11 |
1 files changed, 6 insertions, 5 deletions
diff --git a/src/backend/commands/indexcmds.c b/src/backend/commands/indexcmds.c index ec7e1482798..b951fccb98c 100644 --- a/src/backend/commands/indexcmds.c +++ b/src/backend/commands/indexcmds.c @@ -8,7 +8,7 @@ * * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/commands/indexcmds.c,v 1.85 2002/08/29 15:56:20 tgl Exp $ + * $Header: /cvsroot/pgsql/src/backend/commands/indexcmds.c,v 1.86 2002/08/30 22:18:05 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -735,15 +735,16 @@ ReindexDatabase(const char *dbname, bool force, bool all) heap_close(relationRelation, AccessShareLock); /* Now reindex each rel in a separate transaction */ - CommitTransactionCommand(); + CommitTransactionCommand(true); for (i = 0; i < relcnt; i++) { - StartTransactionCommand(); + StartTransactionCommand(true); if (reindex_relation(relids[i], force)) elog(NOTICE, "relation %u was reindexed", relids[i]); - CommitTransactionCommand(); + CommitTransactionCommand(true); } - StartTransactionCommand(); + /* Tell xact.c not to chain the upcoming commit */ + StartTransactionCommand(true); MemoryContextDelete(private_context); } |