1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
\set VERBOSITY terse
set client_min_messages to ERROR;
-- TODO: merge legacy_validate.sql here
-- See ticket #1789
select null from ( select topology.CreateTopology('t') > 0 ) as ct;
COPY t.node (node_id, containing_face, geom) FROM stdin;
1 \N 01010000000000000000E065C002000000008056C0
2 \N 01010000000000000000E065C000000000008056C0
3 \N 010100000000000000009865C04FE5D4AD958655C0
\.
COPY t.edge_data (edge_id, start_node, end_node, next_left_edge, abs_next_left_edge, next_right_edge, abs_next_right_edge, left_face, right_face, geom) FROM stdin;
1 1 3 2 2 1 1 0 0 0102000000020000000000000000E065C002000000008056C000000000009865C04FE5D4AD958655C0
2 3 2 -2 2 -1 1 0 0 01020000000200000000000000009865C04FE5D4AD958655C00000000000E065C000000000008056C0
\.
SELECT '#1789', * FROM ValidateTopology('t') UNION
SELECT '#1789', '---', null, null ORDER BY 1,2,3,4;
SELECT '#1797', (ValidateTopology('t')).* UNION
SELECT '#1797', '---', null, null ORDER BY 1,2,3,4;
select null from ( select topology.DropTopology('t') ) as dt;
|
