From 9de778b24b7d4040a385486348904db1bf69f677 Mon Sep 17 00:00:00 2001 From: Heikki Linnakangas Date: Wed, 3 Feb 2010 10:01:30 +0000 Subject: Move the responsibility of writing a "unlogged WAL operation" record from heap_sync() to the callers, because heap_sync() is sometimes called even if the operation itself is WAL-logged. This eliminates the bogus unlogged records from CLUSTER that Simon Riggs reported, patch by Fujii Masao. --- src/backend/commands/copy.c | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) (limited to 'src/backend/commands/copy.c') diff --git a/src/backend/commands/copy.c b/src/backend/commands/copy.c index cfaa3927bc..f10ae31ff1 100644 --- a/src/backend/commands/copy.c +++ b/src/backend/commands/copy.c @@ -8,7 +8,7 @@ * * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/commands/copy.c,v 1.322 2010/01/31 18:15:39 tgl Exp $ + * $PostgreSQL: pgsql/src/backend/commands/copy.c,v 1.323 2010/02/03 10:01:29 heikki Exp $ * *------------------------------------------------------------------------- */ @@ -2225,7 +2225,13 @@ CopyFrom(CopyState cstate) * indexes since those use WAL anyway) */ if (hi_options & HEAP_INSERT_SKIP_WAL) + { + char reason[NAMEDATALEN + 30]; + snprintf(reason, sizeof(reason), "COPY FROM on \"%s\"", + RelationGetRelationName(cstate->rel)); + XLogReportUnloggedStatement(reason); heap_sync(cstate->rel); + } } -- cgit v1.2.1