Re: [HACKERS] Patch to log usage of temporary files - Mailing list pgsql-patches

From Bill Moran
Subject Re: [HACKERS] Patch to log usage of temporary files
Date
Msg-id 20070104091812.93f3ec7a.wmoran@collaborativefusion.com
Whole thread Raw
In response to Re: [HACKERS] Patch to log usage of temporary files  ("Andrew Dunstan" <andrew@dunslane.net>)
Responses Re: [HACKERS] Patch to log usage of temporary files
Re: [HACKERS] Patch to log usage of temporary files
List pgsql-patches
In response to "Andrew Dunstan" <andrew@dunslane.net>:

> Bill Moran wrote:
> > Andrew Dunstan <andrew@dunslane.net> wrote:
> >>
> >> Bill Moran wrote:
> >> > +         if (trace_temp_files != -1)
> >> >
> >>
> >> Might be more robust to say
> >>
> >>     if (trace_temp_files >= 0)
> >
> > Because it would allow for the easy addition of more negative numbers
> > with magic value?
>
> because ISTM any negative number here should mean no action is to be
> taken. Otherwise how else is it different from 0?

??

I specified in the GUC config that minimum allowable value is -1.

/usr/local/etc/rc.d/postgresql start
FATAL:  -5 is outside the valid range for parameter "trace_temp_files" (-1 .. 2147483647)

set trace_temp_files to -8;
ERROR:  -8 is outside the valid range for parameter "trace_temp_files" (-1 .. 2147483647)

Perhaps there's another reason to use the >= 0 check, but handling invalid
values with POLA doesn't seem to be a good one.

--
Bill Moran
Collaborative Fusion Inc.

pgsql-patches by date:

Previous
From: "Guillaume Smet"
Date:
Subject: Re: Assorted typos
Next
From: "Simon Riggs"
Date:
Subject: wal_checksum = on (default) | off