Re: [HACKERS] pg_stat_database shows userid as OID

2002-11-21 Thread Bruce Momjian
Does anyone want userid to be an OID? Peter? Anyone? If not, I will add it to the TODO list or work on the patch myself. --- Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Tom Lane wrote: > >> I'd recomme

Re: [HACKERS] pg_stat_database shows userid as OID

2002-11-17 Thread Bruce Momjian
I totally agree with what you have said. Peter, can you clarify your reasoning for OID for user/group id? --- Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Tom Lane wrote: > >> I'd recommend not making any

Re: [HACKERS] pg_stat_database shows userid as OID

2002-11-17 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> I'd recommend not making any piecemeal changes, especially not when >> there's not yet a consensus which way to converge. > Well, seems we should make it consistent at least. I think the original argument stemmed from the idea that we

Re: [HACKERS] pg_stat_database shows userid as OID

2002-11-17 Thread Bruce Momjian
Tom Lane wrote: > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > 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? > > There's been disagreement for a long time over whether userids should be > OIDs or ints. If

Re: [HACKERS] pg_stat_database shows userid as OID

2002-11-17 Thread Alvaro Herrera
On Sun, Nov 17, 2002 at 01:16:29PM -0500, Tom Lane wrote: > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > 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? > > There's been disagreement for a long time over whet

Re: [HACKERS] pg_stat_database shows userid as OID

2002-11-17 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > 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? There's been disagreement for a long time over whether userids should be OIDs or ints. If you want to introduce consis

[HACKERS] pg_stat_database shows userid as OID

2002-11-17 Thread Alvaro Herrera
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