From 2f6cf7f3fd477ea891277cf50b798a4ec5f8fb45 Mon Sep 17 00:00:00 2001 From: jollytoad Date: Mon, 17 Oct 2005 08:28:23 +0000 Subject: [PATCH] Get owner for functions. --- classes/database/Postgres73.php | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/classes/database/Postgres73.php b/classes/database/Postgres73.php index ba7db9a9..cb4bdc6b 100644 --- a/classes/database/Postgres73.php +++ b/classes/database/Postgres73.php @@ -4,7 +4,7 @@ * A class that implements the DB interface for Postgres * Note: This class uses ADODB and returns RecordSets. * - * $Id: Postgres73.php,v 1.153 2005/09/07 08:09:21 chriskl Exp $ + * $Id: Postgres73.php,v 1.154 2005/10/17 08:28:23 jollytoad Exp $ */ // @@@ THOUGHT: What about inherits? ie. use of ONLY??? @@ -754,10 +754,12 @@ class Postgres73 extends Postgres72 { pl.lanname AS prolanguage, pg_catalog.obj_description(p.oid, 'pg_proc') AS procomment, p.proname || ' (' || pg_catalog.oidvectortypes(p.proargtypes) || ')' AS proproto, - CASE WHEN p.proretset THEN 'setof ' ELSE '' END || pg_catalog.format_type(p.prorettype, NULL) AS proreturns + CASE WHEN p.proretset THEN 'setof ' ELSE '' END || pg_catalog.format_type(p.prorettype, NULL) AS proreturns, + u.usename AS proowner FROM pg_catalog.pg_proc p INNER JOIN pg_catalog.pg_namespace n ON n.oid = p.pronamespace INNER JOIN pg_catalog.pg_language pl ON pl.oid = p.prolang + LEFT JOIN pg_catalog.pg_user u ON u.usesysid = p.proowner WHERE NOT p.proisagg AND {$where} ORDER BY p.proname, proresult -- 2.39.5