Opened 12 years ago

Closed 12 years ago

#1325 closed defect (fixed)

topology_upgrade_20_minor.sql is harmful

Reported by: strk Owned by: strk
Priority: high Milestone: PostGIS 2.0.0
Component: topology Version: master
Keywords: Cc:

Description

Right after sourcing topology_upgrade_20_minor.sql, my topology.CreateTopology() doesn't work anymore.

See this session:

strk=# select droptopology('tt');
Topology 'tt' dropped
strk=# select createtopology('tt');
ERROR:  schema "tt" does not exist

Sourcing topology.sql fixes things again:

strk=# select droptopology('tt');
Topology 'tt' dropped
strk=# select createtopology('tt');
2086

Sourcing topology_upgrade_20_minor.sql breaks again as in the first example.

Change History (3)

comment:1 by strk, 12 years ago

The upgrade script generator is stripping a line:

        EXECUTE '
CREATE SCHEMA ' || quote_ident(atopology) || ';
        ';

Becomes:

        EXECUTE '
        ';

No wonder it fails…

comment:2 by strk, 12 years ago

Owner: changed from robe to strk
Status: newassigned

comment:3 by strk, 12 years ago

Resolution: fixed
Status: assignedclosed

Fixed in r8239 by changing topology.sql so to be less confusing to sed.

Note: See TracTickets for help on using tickets.