[postgis-tickets] r17955 - Use BEGIN-ROLLBACK instead of RESET

[Raul]

Author: algunenano
Date: 2019-10-18 05:18:06 -0700 (Fri, 18 Oct 2019)
New Revision: 17955

Modified:
   trunk/regress/core/dump.sql
   trunk/regress/core/isvaliddetail.sql
Log:
Use BEGIN-ROLLBACK instead of RESET



Modified: trunk/regress/core/dump.sql
===================================================================
--- trunk/regress/core/dump.sql	2019-10-18 12:06:31 UTC (rev 17954)
+++ trunk/regress/core/dump.sql	2019-10-18 12:18:06 UTC (rev 17955)
@@ -180,6 +180,7 @@
 ');
 
 -- Check that it works without the extension schema being available
+BEGIN;
 SET search_path TO pg_catalog;
 WITH data AS
 (
@@ -188,4 +189,4 @@
 SELECT	't12',
 	:schema ST_AsText((public.ST_Dump(geom)).geom),
 	:schema ST_AsText((public.ST_DumpRings(geom)).geom) FROM data;
-RESET search_path;
+ROLLBACK;

Modified: trunk/regress/core/isvaliddetail.sql
===================================================================
--- trunk/regress/core/isvaliddetail.sql	2019-10-18 12:06:31 UTC (rev 17954)
+++ trunk/regress/core/isvaliddetail.sql	2019-10-18 12:18:06 UTC (rev 17955)
@@ -49,6 +49,7 @@
 'POLYGON ((70 250, 40 500, 100 400, 70 250, 80 350, 60 350, 70 250))' , 1);
 
 -- Check that it works without the extension schema being available
+BEGIN;
 SET search_path TO pg_catalog;
 select 7, valid, reason, :schema st_astext(location) FROM (
   SELECT (:schema ST_IsValidDetail(
@@ -55,5 +56,5 @@
     'POLYGON ((70 250, 70 500, 80 400, 40 400, 70 250))':: :schema geometry
   )).*
 ) foo;
-RESET search_path;
+ROLLBACK;