postgres.git / summary / log / commit / refs

commit    a3df0d43d93789777fd06bb7ffa8cdc1f06d63c3
Author:   Michael Paquier <michael@paquier.xyz>
Date:     Tue Jul 01 00:41:42 2025 +0000

    Fix typo in system_views.sql's definition of pg_stat_activity
    
    backend_xmin used a lower-character 's' instead of the upper-character
    'S' like the other attributes.  This is harmless, but let's be
    consistent.
    
    Issue introduced in dd1a3bccca24.
    
    Author: Daisuke Higuchi <higuchi.daisuke11@gmail.com>
    Discussion: https://postgr.es/m/CAEVT6c8M39cqWje-df39wWr0KWcDgGKd5fMvQo84zvCXKoEL9Q@mail.gmail.com


 src/backend/catalog/system_views.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

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


[parent: 2e947217474c]