From 7ef009336f14268ff4d252456a799c97fd812450 Mon Sep 17 00:00:00 2001 From: Jakub Vrana Date: Tue, 11 Mar 2025 13:07:00 +0100 Subject: [PATCH] PostgreSQL: Fix where and order privileges (fix #902) --- adminer/drivers/pgsql.inc.php | 2 +- changes.txt | 1 + 2 files changed, 2 insertions(+), 1 deletion(-) diff --git a/adminer/drivers/pgsql.inc.php b/adminer/drivers/pgsql.inc.php index b601d79f..aaba89d2 100644 --- a/adminer/drivers/pgsql.inc.php +++ b/adminer/drivers/pgsql.inc.php @@ -461,7 +461,7 @@ ORDER BY a.attnum") as $row $row["generated"] = ($row["attgenerated"] == "s" ? "STORED" : ""); $row["null"] = !$row["attnotnull"]; $row["auto_increment"] = $row['attidentity'] || preg_match('~^nextval\(~i', $row["default"]); - $row["privileges"] = array("insert" => 1, "select" => 1, "update" => 1); + $row["privileges"] = array("insert" => 1, "select" => 1, "update" => 1, "where" => 1, "order" => 1); if (preg_match('~(.+)::[^,)]+(.*)~', $row["default"], $match)) { $row["default"] = ($match[1] == "NULL" ? null : idf_unescape($match[1]) . $match[2]); } diff --git a/changes.txt b/changes.txt index d7535987..8332ec49 100644 --- a/changes.txt +++ b/changes.txt @@ -6,6 +6,7 @@ MySQL: Allow setting default values of text column MySQL: Stop treating enum and set as numbers (bug #475) MySQL, MariaDB: Fix default values with ' (bug #895) MariaDB: Fix creating and altering generated columns (bug #897) +PostgreSQL: Fix "where" and "order" privileges (bug #902, regression from 5.0.2) SQLite: Fix creating table in compiled version (bug #901, regression from 5.0.0) Elastic: Do not pass null values on insert (PR #892) Elastic: Fix displaying sparse rows (PR #893) -- 2.39.5