Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oIZtI-000784-P2 for pgsql-hackers@arkaria.postgresql.org; Mon, 01 Aug 2022 18:11:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oIZtH-0003kL-E9 for pgsql-hackers@arkaria.postgresql.org; Mon, 01 Aug 2022 18:11:43 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oIZtG-0003kC-SB for pgsql-hackers@lists.postgresql.org; Mon, 01 Aug 2022 18:11:43 +0000 Received: from mail-qt1-x831.google.com ([2607:f8b0:4864:20::831]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1oIZtD-0000q9-AT for pgsql-hackers@lists.postgresql.org; Mon, 01 Aug 2022 18:11:41 +0000 Received: by mail-qt1-x831.google.com with SMTP id h22so8680241qta.3 for ; Mon, 01 Aug 2022 11:11:39 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20210112.gappssmtp.com; s=20210112; h=user-agent:in-reply-to:content-disposition:mime-version:references :message-id:subject:cc:to:from:date:from:to:cc; bh=5nwMrmj28rCtFR+yzb0j63IhkuGbSXoqasbkigMyDQU=; b=basyHxicTexXsN7LiV7gm0CneOxkjdcvtMtiXQhDgYCtoh3Uk4ozlKTZL+GLnDznKI vf1saL4iyS4jWyPmjVMwXMjoebA56FKqfrnYI2OtL3jRmPicxEHnYWEk49zYMGfLEJol PaZa6/wRn1g3CDATY/pe4xi67+f/k1yiCRzzwYktyf6PV0IbugrwNeHWyCjYzkK7ikxu EiYYvnxg0raVdo1o9vgeVzYHpIh4+NmzRkZ9xCJcfKHEK63XlRm96idC6ldgS5EnyTM3 DT8G9as8lhtLOawbem2EuL+5SvYWwdiBHUAHAh8kyQ12wnIXGsc3zVit6lwwIVo3XvRN xLyw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=user-agent:in-reply-to:content-disposition:mime-version:references :message-id:subject:cc:to:from:date:x-gm-message-state:from:to:cc; bh=5nwMrmj28rCtFR+yzb0j63IhkuGbSXoqasbkigMyDQU=; b=RLrTW7BeCcMdM/3YKyuSvuv9/s4ZJAQlDJq2TZku5kSmQqHSYWd7dOSMREYxqJh3Y1 5fPy12+oEMWM+31DiAiupKddDUcvVqxpPIfP/HWa3WIVOEvi5DQv29/tdcPZh2s+AoEo /QpaK0czdF6K/UtMFujYcb9wSh0Hazfuvx9xC+diJWQH96EvWVnrf/OyQOnw5C2J8y7l vyfFkELl+fvJrB45qB3qu2DRVE4qanfMrE1Wv5PYH+HE/jLllw4Ej2Al2kMqsc6Zi1YZ aIa2CG/4QZSMTZIfzIviveGiFywrUAggJ7qi0QFf43PazC3aZ836DQu6BcyJnaLdVxgZ XvKA== X-Gm-Message-State: AJIora/9ISUwxSRXxFd+3yk8DWPXZmnCKLeHAGoXovq38I4Ka1rCKMxG x/n2uiDhDlubUJYMKeTO5oQgOIhE98cV8w== X-Google-Smtp-Source: AGRyM1vuLMC7o/H2iVBu6nNGyO0eg5nAE3lEV0tkl5pJBu8k3aLmszBrOpslvQa9+4pC6WpJAablzw== X-Received: by 2002:a05:622a:18a4:b0:31e:e6f0:42e3 with SMTP id v36-20020a05622a18a400b0031ee6f042e3mr15642393qtc.290.1659377498319; Mon, 01 Aug 2022 11:11:38 -0700 (PDT) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id c69-20020a379a48000000b006b5e1aeb777sm8524300qke.43.2022.08.01.11.11.37 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Mon, 01 Aug 2022 11:11:37 -0700 (PDT) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 15E05800DCA; Mon, 1 Aug 2022 13:11:37 -0500 (CDT) Date: Mon, 1 Aug 2022 13:11:36 -0500 From: Justin Pryzby To: Erik Rijkers Cc: pgsql-hackers@lists.postgresql.org Subject: Re: fix typos Message-ID: <20220801181136.GJ15006@telsasoft.com> References: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="GN/IAAAoV4GJoJGS" Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --GN/IAAAoV4GJoJGS Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Mon, Aug 01, 2022 at 08:04:54PM +0200, Erik Rijkers wrote: > Recent typos... LGTM, thanks. Here are some others I've been sitting on, mostly in .c files. -- Justin --GN/IAAAoV4GJoJGS Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename="0001-typos.patch" From 19f320438476aff2773440447f167d06051a0a47 Mon Sep 17 00:00:00 2001 From: Justin Pryzby Date: Tue, 5 Jul 2022 14:12:26 -0500 Subject: [PATCH 1/4] typos --- doc/src/sgml/brin.sgml | 2 +- src/backend/commands/dbcommands.c | 6 +++--- src/include/replication/reorderbuffer.h | 2 +- 3 files changed, 5 insertions(+), 5 deletions(-) diff --git a/doc/src/sgml/brin.sgml b/doc/src/sgml/brin.sgml index 4ee8908b65a..71697155d7c 100644 --- a/doc/src/sgml/brin.sgml +++ b/doc/src/sgml/brin.sgml @@ -75,7 +75,7 @@ summarized will cause the summary information to be updated with data from the new tuples. When a new page is created that does not fall within the last - summarized range, the range that the new page belongs into + summarized range, the range that the new page belongs to does not automatically acquire a summary tuple; those tuples remain unsummarized until a summarization run is invoked later, creating the initial summary for that range. diff --git a/src/backend/commands/dbcommands.c b/src/backend/commands/dbcommands.c index 7bc53f3a0bb..9f990a8d68f 100644 --- a/src/backend/commands/dbcommands.c +++ b/src/backend/commands/dbcommands.c @@ -188,7 +188,7 @@ CreateDatabaseUsingWalLog(Oid src_dboid, Oid dst_dboid, /* * If the relation is from the source db's default tablespace then we - * need to create it in the destinations db's default tablespace. + * need to create it in the destination db's default tablespace. * Otherwise, we need to create in the same tablespace as it is in the * source database. */ @@ -1351,8 +1351,8 @@ createdb(ParseState *pstate, const CreatedbStmt *stmt) /* * If we're going to be reading data for the to-be-created database into * shared_buffers, take a lock on it. Nobody should know that this - * database exists yet, but it's good to maintain the invariant that a - * lock an AccessExclusiveLock on the database is sufficient to drop all + * database exists yet, but it's good to maintain the invariant that an + * AccessExclusiveLock on the database is sufficient to drop all * of its buffers without worrying about more being read later. * * Note that we need to do this before entering the diff --git a/src/include/replication/reorderbuffer.h b/src/include/replication/reorderbuffer.h index d109d0baede..2c9206ace41 100644 --- a/src/include/replication/reorderbuffer.h +++ b/src/include/replication/reorderbuffer.h @@ -262,7 +262,7 @@ typedef struct ReorderBufferTXN * aborted. This can be a * * plain commit record * * plain commit record, of a parent transaction - * * prepared tansaction + * * prepared transaction * * prepared transaction commit * * plain abort record * * prepared transaction abort -- 2.17.1 --GN/IAAAoV4GJoJGS Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename="0002-fix-whitespace.patch" From 57b1a6001b2910c9a8002e72f22391255e8b8bb9 Mon Sep 17 00:00:00 2001 From: Justin Pryzby Date: Sat, 23 Jul 2022 15:10:01 -0500 Subject: [PATCH 2/4] fix whitespace weird since c91560defc57f89f7e88632ea14ae77b5cec78ee --- src/backend/utils/cache/inval.c | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/src/backend/utils/cache/inval.c b/src/backend/utils/cache/inval.c index eb5782f82a4..c0e33c0f177 100644 --- a/src/backend/utils/cache/inval.c +++ b/src/backend/utils/cache/inval.c @@ -9,8 +9,8 @@ * consider that it is *still valid* so long as we are in the same command, * ie, until the next CommandCounterIncrement() or transaction commit. * (See access/heap/heapam_visibility.c, and note that system catalogs are - * generally scanned under the most current snapshot available, rather than - * the transaction snapshot.) At the command boundary, the old tuple stops + * generally scanned under the most current snapshot available, rather than + * the transaction snapshot.) At the command boundary, the old tuple stops * being valid and the new version, if any, becomes valid. Therefore, * we cannot simply flush a tuple from the system caches during heap_update() * or heap_delete(). The tuple is still good at that point; what's more, -- 2.17.1 --GN/IAAAoV4GJoJGS Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename="0003-f-newline.patch" From 6fc057ae26567f39b85902933e4eddc9cbd9c915 Mon Sep 17 00:00:00 2001 From: Justin Pryzby Date: Tue, 26 Jul 2022 18:34:08 -0500 Subject: [PATCH 3/4] f!newline --- src/backend/commands/explain.c | 1 - 1 file changed, 1 deletion(-) diff --git a/src/backend/commands/explain.c b/src/backend/commands/explain.c index e29c2ae206f..e078456b191 100644 --- a/src/backend/commands/explain.c +++ b/src/backend/commands/explain.c @@ -3284,7 +3284,6 @@ show_hashagg_info(AggState *aggstate, ExplainState *es) if (es->format != EXPLAIN_FORMAT_TEXT) { - if (es->costs) ExplainPropertyInteger("Planned Partitions", NULL, aggstate->hash_planned_partitions, es); -- 2.17.1 --GN/IAAAoV4GJoJGS Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename="0004-print-oids-with-u.patch" From 050de51a3018ed4e609a9f77385708af1692b720 Mon Sep 17 00:00:00 2001 From: Justin Pryzby Date: Sun, 31 Jul 2022 00:30:53 -0500 Subject: [PATCH 4/4] print oids with %u --- src/backend/replication/logical/origin.c | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/src/backend/replication/logical/origin.c b/src/backend/replication/logical/origin.c index c72ad6b93de..ac12f5e26cb 100644 --- a/src/backend/replication/logical/origin.c +++ b/src/backend/replication/logical/origin.c @@ -364,7 +364,7 @@ restart: if (nowait) ereport(ERROR, (errcode(ERRCODE_OBJECT_IN_USE), - errmsg("could not drop replication origin with OID %d, in use by PID %d", + errmsg("could not drop replication origin with OID %u, in use by PID %d", state->roident, state->acquired_by))); @@ -937,7 +937,7 @@ replorigin_advance(RepOriginId node, { ereport(ERROR, (errcode(ERRCODE_OBJECT_IN_USE), - errmsg("replication origin with OID %d is already active for PID %d", + errmsg("replication origin with OID %u is already active for PID %d", replication_state->roident, replication_state->acquired_by))); } @@ -1126,7 +1126,7 @@ replorigin_session_setup(RepOriginId node) { ereport(ERROR, (errcode(ERRCODE_OBJECT_IN_USE), - errmsg("replication origin with OID %d is already active for PID %d", + errmsg("replication origin with OID %u is already active for PID %d", curstate->roident, curstate->acquired_by))); } -- 2.17.1 --GN/IAAAoV4GJoJGS--