Typo in pg_stat_activity definition

From: Daisuke Higuchi <higuchi(dot)daisuke11(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Typo in pg_stat_activity definition
Date: 2025-06-30 04:44:58
Message-ID: CAEVT6c8M39cqWje-df39wWr0KWcDgGKd5fMvQo84zvCXKoEL9Q@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I noticed an inconsistency between uppercase and lowercase letters in only
one place of pg_stat_activity definition, so I'll report it. I think this
is just a typo and there is no functionality issue.
When I compared to the content before and after, I think the capital letter
"S" than "s" is suitable for alias, as shown below.

```diff
diff --git a/src/backend/catalog/system_views.sql
b/src/backend/catalog/system_views.sql
index 08f780a2e63..e5dbbe61b81 100644
--- a/src/backend/catalog/system_views.sql
+++ b/src/backend/catalog/system_views.sql
@@ -895,7 +895,7 @@ CREATE VIEW pg_stat_activity AS
S.wait_event,
S.state,
S.backend_xid,
- s.backend_xmin,
+ S.backend_xmin,
S.query_id,
S.query,
S.backend_type
```

Regards

Attachment Content-Type Size
typo.patch application/x-patch 475 bytes

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2025-06-30 04:51:45 Re: Typo in pg_stat_activity definition
Previous Message Ashutosh Bapat 2025-06-30 04:29:23 Re: pg_get_multixact_members not documented