![[tokkee]](http://tokkee.org/images/avatar.png){kind=avatar}
| author | Sebastian Harl <sh@tokkee.org> | |
| Sat, 7 Mar 2009 16:43:54 +0000 (17:43 +0100) | ||
| committer | Sebastian Harl <sh@tokkee.org> | |
| Sat, 7 Mar 2009 17:00:19 +0000 (18:00 +0100) | ||
| commit | 54fb57fbc5658fc3d150219d07d840178d64d087 | |
| tree | 028b6be9e82affd6f79a67997f847bd8247ac1e3 | tree | snapshot |
| parent | a025295971e7f8d88764c7d54fb29379b9f29b8d | commit | diff |
postgresql_default.conf: Make sure the "disk_io" query does not return NULLs.
Starting with some version between 8.3.3 and 8.3.6, pg_statio_*_tables returns
NULL instead of 0 for statistics if no instance of the appropriate relation
exists. PQgetvalue() returns an empty string in that case which would then
result in error messages when udb_result_submit() tries to convert that to a
number.
Now, the "disk_io" query uses PostgreSQL's coalesce() function to make sure 0
is returned instead of NULL.
Starting with some version between 8.3.3 and 8.3.6, pg_statio_*_tables returns
NULL instead of 0 for statistics if no instance of the appropriate relation
exists. PQgetvalue() returns an empty string in that case which would then
result in error messages when udb_result_submit() tries to convert that to a
number.
Now, the "disk_io" query uses PostgreSQL's coalesce() function to make sure 0
is returned instead of NULL.
| src/postgresql_default.conf | diff | blob | history |