Re: stats_command_string default?

From: Kevin Brown <kevin(at)sysexperts(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: stats_command_string default?
Date: 2003-03-07 04:10:31
Message-ID: 20030307041031.GV1833@filer
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Tom Lane wrote:
> Kevin Brown <kevin(at)sysexperts(dot)com> writes:

[...]

> > It would also be handy if users could see their own queries while the
> > rest remain blank. That would require changing
> > pg_stat_get_backend_activity() so that it returns a value if the user
> > is the superuser or if the user asking for the answer is the same as
> > the user who owns the backend entry being looked up. Are there any
> > pitfalls to implementing that?
>
> Seems reasonable offhand ...

Here's the patch to make this happen. The first is against 7.2.4, the
second is against CVS tip.

If I got it wrong and need to use something other than GetUserId(),
please let me know.

--
Kevin Brown kevin(at)sysexperts(dot)com

Attachment Content-Type Size
pgsql-7.2.4-pgstatfuncs.c.diff text/plain 474 bytes
pgsql-tip-pgstatfuncs.c.diff text/plain 693 bytes

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-03-07 04:32:11 Re: Bad crash, pg_clog files missing ... ?
Previous Message Marc G. Fournier 2003-03-07 02:10:15 Bad crash, pg_clog files missing ... ?

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2003-03-07 05:07:56 Re: stats_command_string default?
Previous Message 박성호 2003-03-07 02:25:54 MD5 test vector