![[tokkee]](http://tokkee.org/images/avatar.png){kind=avatar}
| author | Sebastian Harl <sh@tokkee.org> | |
| Mon, 9 Mar 2009 16:42:48 +0000 (17:42 +0100) | ||
| committer | Sebastian Harl <sh@tokkee.org> | |
| Mon, 9 Mar 2009 16:44:46 +0000 (17:44 +0100) | ||
| commit | 5b903bf6e3e15538abcbbfdec480484a09c1eb1b | |
| tree | c3fe03615ca907011523de982343b4ca0a381358 | tree | snapshot |
| parent | bf76edff067fb8ba29ba4caa5f44622655fec8ff | commit | diff |
patches/postgresql_conf_fix.dpatch: Make sure "disk_io" doesn't return 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.
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.
| debian/changelog | diff | blob | history | |
| debian/patches/postgresql_conf_fix.dpatch | diff | blob | history |