From 543e1725138e80f1d5259d0a82db0c33c921305b Mon Sep 17 00:00:00 2001 From: Jakub Vrana Date: Wed, 21 Dec 2011 21:59:24 -0800 Subject: [PATCH] Respect namespace in foreign keys (thanks to Kleps Ota) --- adminer/drivers/pgsql.inc.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/adminer/drivers/pgsql.inc.php b/adminer/drivers/pgsql.inc.php index dfbd5d22..fec92a29 100644 --- a/adminer/drivers/pgsql.inc.php +++ b/adminer/drivers/pgsql.inc.php @@ -276,7 +276,7 @@ ORDER BY a.attnum" $return = array(); foreach (get_rows("SELECT conname, pg_get_constraintdef(oid) AS definition FROM pg_constraint -WHERE conrelid = (SELECT oid FROM pg_class WHERE relname = " . q($table) . ") +WHERE conrelid = (SELECT pc.oid FROM pg_class AS pc INNER JOIN pg_namespace AS pn ON (pn.oid = pc.relnamespace) WHERE pc.relname = " . q($table) . " AND pn.nspname = current_schema()) AND contype = 'f'::char ORDER BY conkey, conname") as $row) { if (preg_match('~FOREIGN KEY\s*\((.+)\)\s*REFERENCES (.+)\((.+)\)(.*)$~iA', $row['definition'], $match)) { -- 2.39.5