From: Gunnar \"Nick\" Bluth <gunnar.bluth@pro-open.de>
To: pgsql-admin@postgresql.org
Subject: Re: Postgresql 9.3 Postgis 2.1
Date: Mon, 25 Jan 2016 18:48:34 +0100
Message-ID: <56A65FF2.40404@pro-open.de> (raw)
In-Reply-To: <HE1PR03MB117744CA4A013014733321A4D6C70@HE1PR03MB1177.eurprd03.prod.outlook.com>
References: <HE1PR03MB117744CA4A013014733321A4D6C70@HE1PR03MB1177.eurprd03.prod.outlook.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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-adminAttachments:
0x3289338C.asc (application/pgp-keys, 1.7K) download
0x3289338C.asc.sig (application/octet-stream, 287B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: gunnar.bluth@pro-open.de
Subject: Re: Postgresql 9.3 Postgis 2.1
In-Reply-To: <56A65FF2.40404@pro-open.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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