From e5b07c4d169d7c0ae766592ea2ea6257a636ec54 Mon Sep 17 00:00:00 2001
From: River Tarnell <river@users.mediawiki.org>
Date: Thu, 8 Mar 2007 20:29:19 +0000
Subject: [PATCH] need to actually implement pg_fkey_deltype()

---
 maintenance/updaters.inc | 18 ++++++++++++++++++
 1 file changed, 18 insertions(+)

diff --git a/maintenance/updaters.inc b/maintenance/updaters.inc
index b3aaabb3b1..f129e2477a 100644
--- a/maintenance/updaters.inc
+++ b/maintenance/updaters.inc
@@ -1225,6 +1225,24 @@ global	$wgDatabase, $wgDBmwschema;
 	return $exists === $rule;
 }
 
+function
+pg_fkey_deltype($fkey)
+{
+global	$wgDatabase, $wgDBmwschema;
+	$q = <<<END
+SELECT confdeltype FROM pg_constraint, pg_namespace
+	WHERE connamespace=pg_namespace.oid
+	  AND nspname=%s
+	  AND conname=%s;
+END;
+	$r = $wgDatabase->query(sprintf($q,
+		$wgDatabase->addQuotes($wgDBmwschema),
+		$wgDatabase->addQuotes($fkey)));
+	if (!($row = $wgDatabase->fetchRow($r)))
+		return null;
+	return $row[0];
+}
+
 function do_postgres_updates() {
 	global $wgDatabase, $wgVersion, $wgDBmwschema;
 
-- 
2.20.1