| 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 |
| 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 |