pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgresql 9.3 Postgis 2.1
2+ messages / 2 participants
[nested] [flat]
* Postgresql 9.3 Postgis 2.1
@ 2016-01-25 12:02 SELCUK AYDIN <selcuk.aydin@netcad.com.tr>
0 siblings, 1 reply; 2+ messages in thread
From: SELCUK AYDIN @ 2016-01-25 12:02 UTC (permalink / raw)
To: pgsql-admin
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
[NETCAD] <http://www.netcad.com.tr/;
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Postgresql 9.3 Postgis 2.1
@ 2016-01-25 17:48 Gunnar "Nick" Bluth <gunnar.bluth@pro-open.de>
parent: SELCUK AYDIN <selcuk.aydin@netcad.com.tr>
0 siblings, 0 replies; 2+ messages in thread
From: Gunnar \"Nick\" Bluth @ 2016-01-25 17:48 UTC (permalink / raw)
To: 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.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-----
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Attachments:
0x3289338C.asc (application/pgp-keys, 1.7K) download
0x3289338C.asc.sig (application/octet-stream, 287B) download
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2016-01-25 17:48 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2016-01-25 12:02 Postgresql 9.3 Postgis 2.1 SELCUK AYDIN <selcuk.aydin@netcad.com.tr>
2016-01-25 17:48 ` Gunnar "Nick" Bluth <gunnar.bluth@pro-open.de>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox