Re: New contrib: pg_reset_stats()

If you still are wondering about committing it, it only allows a super user
to reset the stats:

australia=# \connect - au-php
You are now connected as new user au-php.
australia=> select pg_reset_stats();
ERROR:  Only database superusers can reset statistic counters

Chris


> -----Original Message-----
> From: pgsql-patches-owner@postgresql.org
> [mailto:pgsql-patches-owner@postgresql.org]On Behalf Of Christopher
> Kings-Lynne
> Sent: Monday, 29 July 2002 3:14 PM
> To: Patches
> Subject: Re: [PATCHES] New contrib: pg_reset_stats()
>
>
> Oh - and could someone please test it on a multibyte install?
>
> Just need to know if I require multibyte headers to be ifdef'd.
>
> Chris
>
> > -----Original Message-----
> > From: pgsql-patches-owner@postgresql.org
> > [mailto:pgsql-patches-owner@postgresql.org]On Behalf Of Christopher
> > Kings-Lynne
> > Sent: Monday, 29 July 2002 3:05 PM
> > To: Patches
> > Subject: [PATCHES] New contrib: pg_reset_stats()
> >
> >
> > Here is a new contrib.  Extract it in the contrib directory and
> > it will make
> > its own subdir.  Needs to be added to the contrib/Makefile.
> >
> > This is a function that allows you to reset the postgres stats collector
> > from within postgres.
> >
> > It's documented, has an sql script and has been tested and works.
> >
> > This function should probably be put in the postgres backend as a
> > builtin at
> > some point methinks...
> >
> > Chris
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>