From: | "Gunnar \"Nick\" Bluth" <gunnar(dot)bluth(at)pro-open(dot)de> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Postgresql 9.3 Postgis 2.1 |
Date: | 2016-01-25 17:48:34 |
Message-ID: | 56A65FF2.40404@pro-open.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
-----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(dot)bluth(at)pro-open(dot)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-----
Attachment | Content-Type | Size |
---|---|---|
0x3289338C.asc | application/pgp-keys | 1.7 KB |
0x3289338C.asc.sig | application/octet-stream | 287 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Clécio Anderson | 2016-01-26 05:12:45 | pg_dump / pg_restore - TOC.dat file |
Previous Message | SELCUK AYDIN | 2016-01-25 12:02:55 | Postgresql 9.3 Postgis 2.1 |