Code

postgresql_default.conf: Make sure the "disk_io" query does not return NULLs.
authorSebastian Harl <sh@tokkee.org>
Sat, 7 Mar 2009 16:43:54 +0000 (17:43 +0100)
committerSebastian Harl <sh@tokkee.org>
Sat, 7 Mar 2009 17:00:19 +0000 (18:00 +0100)
commit54fb57fbc5658fc3d150219d07d840178d64d087
tree028b6be9e82affd6f79a67997f847bd8247ac1e3
parenta025295971e7f8d88764c7d54fb29379b9f29b8d
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.
src/postgresql_default.conf