Hi guys,
I am not sure if I am understanding volatility.
My issue is better explained with a quick example. The function below
expresses call durations in minutes and it is immutable.
CREATE OR REPLACE FUNCTION dur2min(secs INTEGER) RETURNS INTEGER
AS $$
BEGIN
RAISE NOTICE 'BEEN HERE!';
I have, for some months, been running this daily, but not taking notice
of the results:
[EMAIL PROTECTED] ~]$ cat bin/pg_build
#!/bin/bash
set -xe
cd /home/pgtest/pgsql/pgsql-2007-04-23/
ping -c4 2>/dev/null anoncvs.postgresql.org | grep -q 'bytes from'\
&& {
make distclean || :
cvs -q update
./co
John Summerfield wrote:
> I have, for some months, been running this daily, but not taking notice
> of the results:
> [EMAIL PROTECTED] ~]$ cat bin/pg_build
> #!/bin/bash
> set -xe
> cd /home/pgtest/pgsql/pgsql-2007-04-23/
> ping -c4 2>/dev/null anoncvs.postgresql.org | grep -q 'bytes from'\
> && {
Alvaro Herrera wrote:
John Summerfield wrote:
I have, for some months, been running this daily, but not taking notice
of the results:
[EMAIL PROTECTED] ~]$ cat bin/pg_build
#!/bin/bash
set -xe
cd /home/pgtest/pgsql/pgsql-2007-04-23/
ping -c4 2>/dev/null anoncvs.postgresql.org | grep -q 'bytes fr
John Summerfield wrote:
> Alvaro Herrera wrote:
>> Hmm, try deleting the build tree and start again. Sometimes, what
>> happens to me is that somebody adds a new directory, and my build tree
>> does not contain it. It's easy to fix: when I had a slower computer
>> what I did was create the offen
"Fernando Hevia" <[EMAIL PROTECTED]> writes:
> I am not sure if I am understanding volatility.
You're not.
> What bother me are the 3 "been here" messages. As the function is immutable
> and the parameter remains unchanged needs the planner actually execute the
> function 3 times?
The IMMUTABLE
John Summerfield <[EMAIL PROTECTED]> writes:
> -d fixed the missing directories
> and -P prunes obsolete ones.
> Obviously I needed to read the instructions more closely:-(
FWIW, I've used the following ~/.cvsrc for many years:
cvs -z3
update -d -P
checkout -P
The usefulness of -z3 depends on t
