Ticket #1325 (closed defect: fixed)

Opened 18 months ago

Last modified 18 months ago

topology_upgrade_20_minor.sql is harmful

Reported by: strk Owned by: strk
Priority: high Milestone: PostGIS 2.0.0
Component: topology Version: trunk
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

Changed 18 months ago by strk

The upgrade script generator is stripping a line:

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

Becomes:

        EXECUTE '
        ';

No wonder it fails...

Changed 18 months ago by strk

  • owner changed from robe to strk
  • status changed from new to assigned

Changed 18 months ago by strk

  • status changed from assigned to closed
  • resolution set to fixed

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

Note: See TracTickets for help on using tickets.