[postgis-users] POINT/MULTIPOINT EMPTY problem in dump

[Jan Michálek]

I need to solve this problem

I have in table column POINT, some of values ARE 'POINT EMPTY' (dont ask me
why, it is not my table).
MULTIPOINT EMPTY and POINT EMPTY has same representation
(010400000000000000).
If i try restore table from dump, it is problem because postgis read this
as multipoint empty, but the column has type POINT.
My version of postgis

jelen=# select postgis_version();
            postgis_version
---------------------------------------
 2.1 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
(1 row)

Postgre is 9.3.

Is there somebody who knows how to solve this problem?

Thanks Je;

----------
jelen=# CREATE TABLE t3 (id serial primary key, geom geometry(POINT, 0));
CREATE TABLE
jelen=# insert into t3(geom) VALUES ('POINT EMPTY'::geometry);
INSERT 0 1
jelen=# SELECT geom from t3;
        geom
--------------------
 010400000000000000
(1 row)

jelen=# SELECT ST_AsText('010400000000000000');
    st_astext
------------------
 MULTIPOINT EMPTY
(1 row)

jelen=# INSERT INTO t3(geom) values('010400000000000000');
ERROR:  Geometry type (MultiPoint) does not match column type (Point)
jelen=# insert into t3(geom) SELECT geom FROM t3;
INSERT 0 1
jelen=#
-------------------------------


-- 
Jelen
Starší čeledín datovýho chlíva
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20160522/ce629859/attachment.html>