[postgis-tickets] r17317 - Take out schema qualify in constraint see if it resolves failing check constraint check on bessie and debbie

[Regina Obe]

Author: robe
Date: 2019-03-10 01:07:15 -0800 (Sun, 10 Mar 2019)
New Revision: 17317

Modified:
   branches/2.5/raster/rt_pg/rtpostgis.sql.in
Log:
Take out schema qualify in constraint see if it resolves failing check constraint check on bessie and debbie
Reference #4291 for PostGIS 2.5.2

Modified: branches/2.5/raster/rt_pg/rtpostgis.sql.in
===================================================================
--- branches/2.5/raster/rt_pg/rtpostgis.sql.in	2019-03-10 07:20:42 UTC (rev 17316)
+++ branches/2.5/raster/rt_pg/rtpostgis.sql.in	2019-03-10 09:07:15 UTC (rev 17317)
@@ -7496,7 +7496,7 @@
 			|| ' ADD CONSTRAINT ' || quote_ident(cn)
 			|| ' CHECK ( @extschema at .st_envelope('
 			|| quote_ident($3)
-			|| ') @ ''' || attr || '''::@extschema at .geometry) NOT VALID';
+			|| ') @ ''' || attr || '''::geometry) NOT VALID';
 		RETURN  @extschema at ._add_raster_constraint(cn, sql);
 	END;
 	$$ LANGUAGE 'plpgsql' VOLATILE STRICT