Thread: Postgresql 9.3 Postgis 2.1
Hello,
I have a problem.
When I execute this command;
alter TABLE ada alter column poly type geometry(GEOMETRY);
or
alter TABLE ada alter column poly type geometry(geometry,32768);
I get this message:
ERROR: Geometry has Z dimension but column does not
********** Error **********
ERROR: Geometry has Z dimension but column does not
SQL state: 22023
how I solve this problem;
Could you help me?
Thanks
Your sincerely.
SELCUK AYDIN PROJE UZMANI selcuk.aydin@netcad.com.tr Cyber Park B Blok No:409 06800, Bilkent / Ankara Tel. :(312) 265 0510 - 1192 Faks: (312) 265 0520 |
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Am 25.01.2016 um 13:02 schrieb SELCUK AYDIN: > Hello, I have a problem. > > When I execute this command; > > *alter TABLE ada alter column poly type geometry(GEOMETRY);* > > or > > *alter TABLE ada alter column poly type geometry(geometry,32768);* > > I get this message: > > ERROR: Geometry has Z dimension but column does not > > ********** Error ********** > > ERROR: Geometry has Z dimension but column does not > > SQL state: 22023 > > how I solve this problem; Hello Selcuk, I'm not too familiar with those PostGIS data types, however it sounds like you're trying to turn some 2d data into 3d ("Z" as in "X-Y-Z" as opposed to "X-Y"). You'll probably best: - - re-think what you're about to do... maybe geometry is not exactly what you're looking for ;-) - - if you really want to add that 3rd dimension, you'll need to add a "USING ..." to your statement, with some function that takes your X-Y data and adds the Z dimension Best regards, - -- Gunnar "Nick" Bluth RHCE/SCLA Mobil +49 172 8853339 Email: gunnar.bluth@pro-open.de _____________________________________________________________ In 1984 mainstream users were choosing VMS over UNIX. Ten years later they are choosing Windows over UNIX. What part of that message aren't you getting? - Tom Payne -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iQEcBAEBCAAGBQJWpl/xAAoJEBAQrmsyiTOMtg8H/RtuDcMTbC82HGbpI59PIBL+ NY4jLaClbnBm0Yg7w/hKHAbmKJIafrG06ugzrg6MTgv7zd66QyHvLssOWQE2ecea /ek0Zlp5xWh6NL0iDQnH0bRE52jIFP0CRUbFllASEmUwM3P9TGsd2ekQrd6LjPYD CaqJpx+6fv1/OD88I5hvSqTIT08Daab027mrgi9qPq+HKQ5EDDJQMHS4FP/jEn6U w3ueoyuyuaevBdpewTZ0k/g/P11M+PDLJeJPSnDfZqYdng6bRbcZyfjM/vKHMPxi 1YJi3CDe9wQlQKW9kDFaupx9iEQ4R8R+LziEB4clCnQ/KwhhVa1RiAXIVR9y2B4= =XcbO -----END PGP SIGNATURE-----