pg_stat_database shows userid as OID - Mailing list pgsql-hackers

Hello hackers,

In the pg_stat_activity view, the usesysid is shown as having type Oid.
However pg_shadow says it's an integer.  Is there a reason? Looks like
a bug.

This patch seems to corrects this issue, but I don't know if there's
something else involved.

Index: src/include/catalog/pg_proc.h
===================================================================
RCS file: /projects/cvsroot/pgsql-server/src/include/catalog/pg_proc.h,v
retrieving revision 1.276
diff -c -r1.276 pg_proc.h
*** src/include/catalog/pg_proc.h    2002/11/08 17:27:03    1.276
--- src/include/catalog/pg_proc.h    2002/11/16 23:18:44
***************
*** 2738,2744 **** DESCR("Statistics: PID of backend"); DATA(insert OID = 1938 (  pg_stat_get_backend_dbid        PGNSP
PGUID12 f f t f s 1 26 "23"    pg_stat_get_backend_dbid - _null_ )); DESCR("Statistics: Database ID of backend");
 
! DATA(insert OID = 1939 (  pg_stat_get_backend_userid    PGNSP PGUID 12 f f t f s 1 26 "23"
pg_stat_get_backend_userid- _null_ )); DESCR("Statistics: User ID of backend"); DATA(insert OID = 1940 (
pg_stat_get_backend_activity   PGNSP PGUID 12 f f t f s 1 25 "23"    pg_stat_get_backend_activity - _null_ ));
DESCR("Statistics:Current query of backend");
 
--- 2738,2744 ---- DESCR("Statistics: PID of backend"); DATA(insert OID = 1938 (  pg_stat_get_backend_dbid        PGNSP
PGUID12 f f t f s 1 26 "23"    pg_stat_get_backend_dbid - _null_ )); DESCR("Statistics: Database ID of backend");
 
! DATA(insert OID = 1939 (  pg_stat_get_backend_userid    PGNSP PGUID 12 f f t f s 1 23 "23"
pg_stat_get_backend_userid- _null_ )); DESCR("Statistics: User ID of backend"); DATA(insert OID = 1940 (
pg_stat_get_backend_activity   PGNSP PGUID 12 f f t f s 1 25 "23"    pg_stat_get_backend_activity - _null_ ));
DESCR("Statistics:Current query of backend");
 
Index: src/backend/utils/adt/pgstatfuncs.c
===================================================================
RCS file: /projects/cvsroot/pgsql-server/src/backend/utils/adt/pgstatfuncs.c,v
retrieving revision 1.8
diff -c -r1.8 pgstatfuncs.c
*** src/backend/utils/adt/pgstatfuncs.c    2002/08/20 04:47:52    1.8
--- src/backend/utils/adt/pgstatfuncs.c    2002/11/16 23:18:44
***************
*** 272,278 ****     if ((beentry = pgstat_fetch_stat_beentry(beid)) == NULL)         PG_RETURN_NULL(); 
!     PG_RETURN_OID(beentry->userid); }  
--- 272,278 ----     if ((beentry = pgstat_fetch_stat_beentry(beid)) == NULL)         PG_RETURN_NULL(); 
!     PG_RETURN_INT32(beentry->userid); }  
-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"El miedo atento y previsor es la madre de la seguridad" (E. Burke)