File: droptopogeometrycolumn.sql

package info (click to toggle)
postgis 2.5.1%2Bdfsg-1
  • links: PTS, VCS
  • area: main
  • in suites: buster
  • size: 75,792 kB
  • sloc: ansic: 139,314; sql: 136,281; xml: 48,954; sh: 4,906; perl: 4,509; makefile: 2,897; python: 1,198; yacc: 441; cpp: 305; lex: 132
file content (10 lines) | stat: -rw-r--r-- 434 bytes parent folder | download | duplicates (5) 
1
2
3
4
5
6
7
8
9
10
 
set client_min_messages to ERROR;
-- Drop corrupted topology (with missing layer tables)
-- See http://trac.osgeo.org/postgis/ticket/3016
SELECT topology.CreateTopology('t1') > 0;
CREATE TABLE t1f (id int);
SELECT topology.AddTopoGeometryColumn('t1', 'public', 't1f', 'geom_t1', 'LINE') > 0;
DROP TABLE t1.relation;
SELECT topology.DropTopoGeometryColumn('public','t1f','geom_t1');
DROP TABLE t1f;
SELECT topology.DropTopology('t1');