-----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@xxxxxxxxxxx
_____________________________________________________________
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-----
Attachment:
0x3289338C.asc
Description: application/pgp-keys
Attachment:
0x3289338C.asc.sig
Description: Binary data
-- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
