Postgres::getLocks PHP Method

    function getLocks()
    {
        global $conf;
        if (!$conf['show_system']) {
            $where = 'AND pn.nspname NOT LIKE $$pg\\_%$$';
        } else {
            $where = "AND nspname !~ '^pg_t(emp_[0-9]+|oast)\$'";
        }
        $sql = "\n\t\t\tSELECT\n\t\t\t\tpn.nspname, pc.relname AS tablename, pl.pid, pl.mode, pl.granted, pl.virtualtransaction,\n\t\t\t\t(select transactionid from pg_catalog.pg_locks l2 where l2.locktype='transactionid'\n\t\t\t\t\tand l2.mode='ExclusiveLock' and l2.virtualtransaction=pl.virtualtransaction) as transaction\n\t\t\tFROM\n\t\t\t\tpg_catalog.pg_locks pl,\n\t\t\t\tpg_catalog.pg_class pc,\n\t\t\t\tpg_catalog.pg_namespace pn\n\t\t\tWHERE\n\t\t\t\tpl.relation = pc.oid AND pc.relnamespace=pn.oid\n\t\t\t{$where}\n\t\t\tORDER BY pid,nspname,tablename";
        return $this->selectSet($sql);
    }