Menu

#10 adddays recursion causing stack "exceed"

open
PostgreSQL (7)
5
2005-10-06
2005-10-06
Lee
No

PostgresSQL is resistant to crashing from recursive calls.
However, if stderr is redirected to the logs, the logs
can get really huge. Some average 20GB of logs a day!

Temp fix disable the logs

change
redirect_stderr = false

I disabled addDays but making it just return 1.

Kompiere still works but a LOT faster.

If addDays is needed I am guessing it would be like this

timestamp + interval #1days
and not a recursive call to addDays with no terminating
condition.

Discussion

MongoDB Logo MongoDB