Fix upgrade of contrib/xml2 from 9.0.

tglsfdc · tglsfdc · commit de623f33353c · 2011-02-17T18:11:28.000-05:00
Update script was being sloppy about two functions that have been changed
since 9.0.
diff --git a/contrib/xml2/xml2--unpackaged--1.0.sql b/contrib/xml2/xml2--unpackaged--1.0.sql
@@ -13,3 +13,14 @@ ALTER EXTENSION xml2 ADD function xpath_nodeset(text,text,text,text);
 ALTER EXTENSION xml2 ADD function xpath_string(text,text);
 ALTER EXTENSION xml2 ADD function xml_encode_special_chars(text);
 ALTER EXTENSION xml2 ADD function xml_valid(text);
+
+-- xml_valid is now an alias for core xml_is_well_formed()
+
+CREATE OR REPLACE FUNCTION xml_valid(text) RETURNS bool
+AS 'xml_is_well_formed'
+LANGUAGE INTERNAL STRICT STABLE;
+
+-- xml_is_well_formed is now in core, not needed in extension.
+-- be careful to drop extension's copy not core's.
+
+DROP FUNCTION @extschema@.xml_is_well_formed(text);
diff --git a/contrib/xml2/xml2.control b/contrib/xml2/xml2.control
@@ -2,4 +2,5 @@
 comment = 'XPath querying and XSLT'
 default_version = '1.0'
 module_pathname = '$libdir/pgxml'
-relocatable = true
+# non-relocatable because xml2--unpackaged--1.0.sql needs to use @extschema@
+relocatable = false
