From 6174e7932907140a424fb2faed4095e40bb5e9b0 Mon Sep 17 00:00:00 2001 From: "Jehan-Guillaume (ioguix) de Rorthais" Date: Fri, 24 Aug 2012 18:00:33 +0200 Subject: [PATCH] Fix on the processes page with 9.2 Field pg_catalog.pg_stat_activity.procpid is renamed as pid in 9.2 --- classes/database/Postgres.php | 4 ++-- classes/database/Postgres91.php | 19 +++++++++++++++++++ 2 files changed, 21 insertions(+), 2 deletions(-) diff --git a/classes/database/Postgres.php b/classes/database/Postgres.php index 0421989f..2027650c 100755 --- a/classes/database/Postgres.php +++ b/classes/database/Postgres.php @@ -7196,12 +7196,12 @@ class Postgres extends ADODB_base { */ function getProcesses($database = null) { if ($database === null) - $sql = "SELECT * FROM pg_catalog.pg_stat_activity ORDER BY datname, usename, procpid"; + $sql = "SELECT * FROM pg_catalog.pg_stat_activity ORDER BY datname, usename, pid"; else { $this->clean($database); $sql = " SELECT * FROM pg_catalog.pg_stat_activity - WHERE datname='{$database}' ORDER BY usename, procpid"; + WHERE datname='{$database}' ORDER BY usename, pid"; } return $this->selectSet($sql); diff --git a/classes/database/Postgres91.php b/classes/database/Postgres91.php index 613beca8..f7892cc2 100755 --- a/classes/database/Postgres91.php +++ b/classes/database/Postgres91.php @@ -27,6 +27,25 @@ class Postgres91 extends Postgres { return $this->help_page; } + // Administration functions + /** + * Returns all available process information. + * @param $database (optional) Find only connections to specified database + * @return A recordset + */ + function getProcesses($database = null) { + if ($database === null) + $sql = "SELECT * FROM pg_catalog.pg_stat_activity ORDER BY datname, usename, procpid"; + else { + $this->clean($database); + $sql = " + SELECT * FROM pg_catalog.pg_stat_activity + WHERE datname='{$database}' ORDER BY usename, procpid"; + } + + return $this->selectSet($sql); + } + // Tablespace functions /** -- 2.39.5