[postgis-users] CopyTopology cannot copy a topology that "hasz"

John Morrison john.nmi.morrison at gmail.com
Tue Jan 22 09:30:42 PST 2013


Hi;

Tried to copy a topology created with hasz=true via CreateTopology.

The error I got (in pgsql) was:

*temp01=# SELECT topology.CopyTopology('ma_topo', 'ma_topo_copy');
ERROR:  Geometry has Z dimension but column does not
CONTEXT:  SQL statement "INSERT INTO ma_topo_copy.node SELECT * FROM
ma_topo.node"
PL/pgSQL function "copytopology" line 30 at EXECUTE statement
temp01=#
*
Cursory inspection of CopyTopology indicates new topology is created at
line 2151 without the fourth "hasz" argument value, which should presumably
be taken from the old topology.

Version of topology.sql is the following:

*-- $Id: topology.sql.in.c 10644 2012-11-05 10:27:08Z strk $*

fetched via svn from svn.osgeo.org (notably NOT via git from github, whose
topology.sql's relevant line looks the same):

*[jm at jm7 postgis-svn]$ svn info
Path: .
Working Copy Root Path: /usr/local/src/PostGIS/postgis-svn
URL: http://svn.osgeo.org/postgis/trunk
Repository Root: http://svn.osgeo.org/postgis
Repository UUID: b70326c6-7e19-0410-871a-916f4a2858ee
Revision: 10775
Node Kind: directory
Schedule: normal
Last Changed Author: robe
Last Changed Rev: 10775
Last Changed Date: 2012-12-01 03:34:41 -0500 (Sat, 01 Dec 2012)

[jm at jm7 postgis-svn]$ *

Platform is FC17, PostGreSQL is postgresql-9.1.7-1.fc17.x86_64 (stock FC17
with updates)

Please advise if this is either a bug or Pilot Error.

-jm
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130122/c7bc7f33/attachment.html>


More information about the postgis-users mailing list