phppgadmin PostgreSQL 12 issue

phppgadmin จะมีปัญหากับ PostgreSQL 12 เวลา browse table แล้วมันจะ error ประมาณนี้ เพราะคือ คอลัมน์ relhasoids มันไม่มีแล้ว

ERROR: column relhasoids does not exist

https://stackoverflow.com/questions/58758377/how-to-fix-error-column-relhasoids-does-not-exist-in-phppgadmin

แก้ code phppgadmin ประมาณนี้

/usr/share/phppgadmin/classes/database# diff -u Postgres-org.php Postgres.php 
--- Postgres-org.php    2021-05-10 12:24:02.883661674 +0700
+++ Postgres.php        2021-05-10 12:24:33.211848605 +0700
@@ -1043,13 +1043,14 @@
 
                $sql = "SELECT relhasoids FROM pg_catalog.pg_class WHERE relname='{$table}'
                        AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname='{$c_schema}')";
-
+/*
                $rs = $this->selectSet($sql);
                if ($rs->recordCount() != 1) return null;
                else {
                        $rs->fields['relhasoids'] = $this->phpBool($rs->fields['relhasoids']);
                        return $rs->fields['relhasoids'];
                }
+ */
        }
 
        /**

Leave a comment