From 9f67af1913d2d3539cb892890fd121f8a16d46a9 Mon Sep 17 00:00:00 2001
From: Sebastian Harl <sh@tokkee.org>
Date: Tue, 26 Aug 2008 16:11:26 +0200
Subject: [PATCH] postgresql_default.conf: Split "queries" query into two
 versions.

The "n_tup_hot_upd" column has been added in 8.3. The two versions of the
"queries" query now take that into account by defining different SQL queries
for versions up to 8.2.99 and versions starting with 8.3.

Signed-off-by: Sebastian Harl <sh@tokkee.org>
Signed-off-by: Florian Forster <octo@huhu.verplant.org>
---
 src/postgresql_default.conf | 13 +++++++++++++
 1 file changed, 13 insertions(+)

diff --git a/src/postgresql_default.conf b/src/postgresql_default.conf
index decf39f5..61844a02 100644
--- a/src/postgresql_default.conf
+++ b/src/postgresql_default.conf
@@ -21,6 +21,17 @@
 	Column pg_xact rollback
 </Query>
 
+<Query queries>
+	Query "SELECT sum(n_tup_ins), sum(n_tup_upd), sum(n_tup_del) \
+		FROM pg_stat_user_tables;"
+
+	Column pg_n_tup_c ins
+	Column pg_n_tup_c upd
+	Column pg_n_tup_c del
+
+	MaxPGVersion 80299
+</Query>
+
 <Query queries>
 	Query "SELECT sum(n_tup_ins), sum(n_tup_upd), sum(n_tup_del), \
 			sum(n_tup_hot_upd) \
@@ -30,6 +41,8 @@
 	Column pg_n_tup_c upd
 	Column pg_n_tup_c del
 	Column pg_n_tup_c hot_upd
+
+	MinPGVersion 80300
 </Query>
 
 <Query query_plans>
-- 
2.30.2