From 718bbb3745b85631ed9f8e1f2d24d361ecee19b6 Mon Sep 17 00:00:00 2001 From: Sandro Santilli Date: Tue, 27 Mar 2012 17:30:43 +0000 Subject: [PATCH] Wrap most topology.sql into a transaction CREATE SCHEMA is left out because uninstall_topology isn't getting rid of it (to be fixed later) git-svn-id: http://svn.osgeo.org/postgis/trunk@9557 b70326c6-7e19-0410-871a-916f4a2858ee --- topology/topology.sql.in.c | 9 +++++---- 1 file changed, 5 insertions(+), 4 deletions(-) diff --git a/topology/topology.sql.in.c b/topology/topology.sql.in.c index 4273ece4d..25f9a06b3 100644 --- a/topology/topology.sql.in.c +++ b/topology/topology.sql.in.c @@ -189,11 +189,11 @@ -- Let people decide about that -- DROP SCHEMA topology CASCADE; +CREATE SCHEMA topology; + -- Doing everything outside of a transaction helps -- upgrading in the best case. --- BEGIN; - -CREATE SCHEMA topology; +BEGIN; --={ ---------------------------------------------------------------- -- POSTGIS-SPECIFIC block @@ -1982,6 +1982,7 @@ CREATE OR REPLACE FUNCTION postgis_topology_scripts_installed() RETURNS text AS _POSTGIS_SQL_SELECT_POSTGIS_SCRIPTS_VERSION LANGUAGE 'sql' IMMUTABLE; ---COMMIT; -- Make sure topology is in database search path -- SELECT topology.AddToSearchPath('topology'); + +COMMIT; -- 2.50.1