[postgis-tickets] r17061 - Missed a spot in last commit

Regina Obe lr at pcorp.us
Thu Nov 22 11:49:50 PST 2018


Author: robe
Date: 2018-11-22 23:49:49 -0800 (Thu, 22 Nov 2018)
New Revision: 17061

Modified:
   branches/2.5/postgis/postgis.sql.in
Log:
Missed a spot in last commit
Closes #4231 for postgis 2.5.2

Modified: branches/2.5/postgis/postgis.sql.in
===================================================================
--- branches/2.5/postgis/postgis.sql.in	2018-11-22 21:10:50 UTC (rev 17060)
+++ branches/2.5/postgis/postgis.sql.in	2018-11-23 07:49:49 UTC (rev 17061)
@@ -5541,7 +5541,9 @@
 CREATE OR REPLACE FUNCTION postgis_constraint_srid(geomschema text, geomtable text, geomcolumn text) RETURNS integer AS
 $$
 SELECT replace(replace(split_part(s.consrc, ' = ', 2), ')', ''), '(', '')::integer
-		 FROM pg_class c, pg_namespace n, pg_attribute a, pg_constraint s
+		 FROM pg_class c, pg_namespace n, pg_attribute a
+		 , (SELECT connamespace, conrelid, conkey, pg_get_constraintdef(oid) As consrc
+		    FROM pg_constraint) AS s
 		 WHERE n.nspname = $1
 		 AND c.relname = $2
 		 AND a.attname = $3



More information about the postgis-tickets mailing list