From bd677bb4438117d85ea3cd43dd696ea1ce9a4812 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Thu, 18 Nov 2004 01:19:57 +0000 Subject: [PATCH] Back-patch fix for ALTER DATABASE failing to flush pg_database changes to disk right away. This is just a one-liner change rather than trying to use FlushRelationBuffers(). --- src/backend/commands/dbcommands.c | 10 +++++++++- 1 file changed, 9 insertions(+), 1 deletion(-) diff --git a/src/backend/commands/dbcommands.c b/src/backend/commands/dbcommands.c index 79fd2fe97f0..400a244ecf3 100644 --- a/src/backend/commands/dbcommands.c +++ b/src/backend/commands/dbcommands.c @@ -9,7 +9,7 @@ * * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/commands/dbcommands.c,v 1.107.2.1 2002/12/02 05:21:01 tgl Exp $ + * $Header: /cvsroot/pgsql/src/backend/commands/dbcommands.c,v 1.107.2.2 2004/11/18 01:19:57 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -575,6 +575,14 @@ AlterDatabaseSet(AlterDatabaseSetStmt *stmt) heap_endscan(scan); heap_close(rel, RowExclusiveLock); + + /* + * Force dirty buffers out to disk, so that newly-connecting backends + * will see the altered database tuple in pg_database right away. + * (They'll see an uncommitted deletion, but they don't care; see + * GetRawDatabaseInfo.) + */ + BufferSync(); } -- 2.39.5