1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
|
-- PostGIS - Spatial Types for PostgreSQL
-- http://postgis.net
--
-- Copyright (C) 2012 Regina Obe <lr@pcorp.us>
-- This is free software; you can redistribute and/or modify it under
-- the terms of the GNU General Public Licence. See the COPYING file.
--
--
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
-- These are reserved for functions where the they are changed to use default args
-- This is installed after the new functions are installed
-- We don't have any of these yet for topology
-- The reason we put these after install is
-- you can't drop a function that is used by sql functions
-- without forcing a drop on those as well which may cause issues with user functions.
-- This allows us to CREATE OR REPLACE those in general topology.sql
-- without dropping them.
DO $BODY$
DECLARE
rec RECORD;
BEGIN
FOR rec IN
WITH updated AS (
UPDATE topology.topology SET SRID=0 WHERE SRID<0
RETURNING *
)
SELECT * FROM updated
LOOP
-- NOTE: these notices will not be shown during extension upgrade
RAISE NOTICE 'Topology % had SRID<0, updated to the officially unknown SRID value 0', rec.name;
END LOOP;
END;
$BODY$ LANGUAGE 'plpgsql';
|
