Re: Problems with PGOPTIONS

On Wed, 15 Jan 2003 10:01:27 -0500
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Andre Schubert <andre(at)km3(dot)de> writes:
> > I want to enable the collection of STATS_ROW_LEVEL for special backends
> > by setting the environment-variable export PGOPTIONS='-c STATS_ROW_LEVEL=ON'.
> > After setting this variable i cant connect to my database.
> > Everytime the following error occurs:
>
> > Connection to database 'mydb' failed.
> > FATAL 1: permission denied
>
> You cannot alter stats_row_level unless you're a superuser (and I think
> even that exception doesn't work for PGOPTIONS, because it's processed
> before the backend has determined whether you are a superuser). You'd
> get the same error if you tried
>
> regression=> set STATS_ROW_LEVEL = on;
> ERROR: 'stats_row_level': permission denied
>

Ok, but is there another way to enable STATS_ROW_LEVEL for a special backend not
connecting as superuser ?

Regards, as