tion block
+psql:load_topology.sql:185: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:188: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:191: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:194: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:197: ERROR: current transaction is aborted, commands ignored until end of transaction block

-t
-9
-22
-26
+psql:load_topology.sql:28: ERROR: schema "city_data" already exists
+psql:load_topology.sql:35: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:36: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:37: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:38: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:39: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:40: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:41: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:42: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:43: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:46: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:51: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:54: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:57: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:60: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:63: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:66: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:69: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:72: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:75: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:78: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:81: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:84: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:87: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:90: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:93: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:96: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:99: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:102: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:105: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:108: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:111: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:114: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:117: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:122: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:125: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:128: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:131: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:134: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:137: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:140: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:143: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:146: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:149: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:152: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:155: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:158: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:161: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:164: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:167: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:170: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:173: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:176: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:179: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:182: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:185: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:188: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:191: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:194: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_topology.sql:197: ERROR: current transaction is aborted, commands ignored until end of transaction block

COMMIT
BEGIN
1
2
3

+psql:load_features.sql:68: ERROR: Face 3 does not exist in topology city_data
+psql:load_features.sql:76: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_features.sql:83: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_features.sql:90: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_features.sql:97: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_features.sql:106: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_features.sql:113: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_features.sql:120: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_features.sql:127: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_features.sql:137: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_features.sql:144: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_features.sql:151: ERROR: current transaction is aborted, commands ignored until end of transaction block
+psql:load_features.sql:158: ERROR: current transaction is aborted, commands ignored until end of transaction block

COMMIT

-4
-features.big_parcels.the_geom SRID:0 TYPE:MULTIPOLYGON DIMS:2
-5
-6
-features.big_signs.the_geom SRID:0 TYPE:MULTIPOINT DIMS:2
-GeometryType?(traffic_signs)|MULTIPOINT
-ST_GeometryType(traffic_signs)|ST_MultiPoint
-GeometryType?(city_streets)|MULTILINESTRING
-ST_GeometryType(city_streets)|ST_MultiLinestring
-GeometryType?(land_parcels)|MULTIPOLYGON
-ST_GeometryType(land_parcels)|ST_MultiPolygon
-GeometryType?(big_signs)|MULTIPOINT
-ST_GeometryType(big_signs)|ST_MultiPoint
-GeometryType?(big_streets)|MULTILINESTRING
-ST_GeometryType(big_streets)|ST_MultiLinestring
-GeometryType?(big_parcels)|MULTIPOLYGON
-ST_GeometryType(big_parcels)|ST_MultiPolygon
+psql:more_features.sql:11: ERROR: schema "features" does not exist at character 13
+psql:more_features.sql:19: ERROR: schema "features" does not exist at character 13
+psql:more_features.sql:27: ERROR: schema "features" does not exist at character 13
+psql:more_features.sql:35: ERROR: schema "features" does not exist at character 13
+psql:more_features.sql:44: ERROR: schema "features" does not exist at character 13
+psql:more_features.sql:51: ERROR: schema "features" does not exist at character 13
+psql:more_features.sql:58: ERROR: schema "features" does not exist at character 13
+psql:more_features.sql:65: ERROR: schema "features" does not exist at character 13
+psql:more_features.sql:74: ERROR: schema "features" does not exist at character 13
+psql:more_features.sql:81: ERROR: schema "features" does not exist at character 13
+psql:more_features.sql:88: ERROR: schema "features" does not exist at character 13
+psql:more_features.sql:95: ERROR: schema "features" does not exist at character 13
+psql:hierarchy.sql:11: ERROR: schema "features" does not exist
+psql:hierarchy.sql:16: ERROR: schema "features" does not exist
+psql:hierarchy.sql:18: ERROR: Schema 'features' is not a valid schemaname
+psql:hierarchy.sql:25: ERROR: schema "features" does not exist at character 13
+psql:hierarchy.sql:32: ERROR: schema "features" does not exist at character 13
+psql:hierarchy.sql:42: ERROR: schema "features" does not exist at character 13
+psql:hierarchy.sql:50: ERROR: schema "features" does not exist
+psql:hierarchy.sql:55: ERROR: schema "features" does not exist
+psql:hierarchy.sql:65: ERROR: schema "features" does not exist at character 13
+psql:hierarchy.sql:75: ERROR: schema "features" does not exist at character 13
+psql:hierarchy.sql:83: ERROR: schema "features" does not exist
+psql:hierarchy.sql:88: ERROR: schema "features" does not exist
+psql:hierarchy.sql:90: ERROR: Schema 'features' is not a valid schemaname
+psql:hierarchy.sql:97: ERROR: schema "features" does not exist at character 13
+ERROR: schema "features" does not exist at character 76
+ERROR: schema "features" does not exist at character 82
+ERROR: schema "features" does not exist at character 75
+ERROR: schema "features" does not exist at character 81
+ERROR: schema "features" does not exist at character 75
+ERROR: schema "features" does not exist at character 81
+ERROR: schema "features" does not exist at character 72
+ERROR: schema "features" does not exist at character 78
+ERROR: schema "features" does not exist at character 74
+ERROR: schema "features" does not exist at character 80
+ERROR: schema "features" does not exist at character 74
+ERROR: schema "features" does not exist at character 80

-t
-Empty topology errors|0
-Topology 'tt' dropped
+ERROR: function createtopology(unknown) does not exist at character 8
+ERROR: function validatetopology(unknown) does not exist at character 47
+ERROR: function droptopology(unknown) does not exist at character 8

Run tests: 1
Failed: 1psq

show search_path;

search_path

public

(1 row)

select createtopology('tt1'); select createtopology('tt1');

ERROR: function createtopology(unknown) does not exist
LINE 1: select createtopology('tt1');

HINT: No function matches the given name and argument types. You might need to add explicit type casts.

select setting,boot_val,reset_val from pg_settings where name = 'search_path';
select topology.AddToSearchPath('topology');
show search_path;
select setting,boot_val,reset_val from pg_settings where name = 'search_path';