From 0f8460b5e8a121560805f53cec1a3847b652aa7c Mon Sep 17 00:00:00 2001 From: Jakub Vrana Date: Wed, 26 Feb 2025 12:35:25 +0100 Subject: [PATCH] PostgreSQL: Use function for exporting constraints --- adminer/drivers/pgsql.inc.php | 13 ++----------- 1 file changed, 2 insertions(+), 11 deletions(-) diff --git a/adminer/drivers/pgsql.inc.php b/adminer/drivers/pgsql.inc.php index a5e6f8e1..001f241e 100644 --- a/adminer/drivers/pgsql.inc.php +++ b/adminer/drivers/pgsql.inc.php @@ -770,6 +770,7 @@ AND typelem = 0" } function create_sql($table, $auto_increment, $style) { + global $driver; $return_parts = array(); $sequences = array(); @@ -823,17 +824,7 @@ AND typelem = 0" } } - $constraints = get_key_vals("SELECT conname, " . (min_version(8) ? "pg_get_constraintdef(pg_constraint.oid)" : "CONCAT('CHECK ', consrc)") . " -FROM pg_catalog.pg_constraint -INNER JOIN pg_catalog.pg_namespace ON pg_constraint.connamespace = pg_namespace.oid -INNER JOIN pg_catalog.pg_class ON pg_constraint.conrelid = pg_class.oid AND pg_constraint.connamespace = pg_class.relnamespace -WHERE pg_constraint.contype = 'c' -AND conrelid != 0 -- handle only CONSTRAINTs here, not TYPES -AND nspname = current_schema() -AND relname = " . q($table) . " -ORDER BY connamespace, conname" - ); - foreach ($constraints as $conname => $consrc) { + foreach ($driver->checkConstraints($table) as $conname => $consrc) { $return_parts[] = "CONSTRAINT " . idf_escape($conname) . " $consrc"; } -- 2.39.5