Subject: Re: Postgresql 9.3 Postgis 2.1
To: pgsql-admin@postgresql.org
References: 
 <HE1PR03MB117744CA4A013014733321A4D6C70@HE1PR03MB1177.eurprd03.prod.outlook.com>
From: "Gunnar \"Nick\" Bluth" <gunnar.bluth@pro-open.de>
Message-ID: <56A65FF2.40404@pro-open.de>
Date: Mon, 25 Jan 2016 18:48:34 +0100
User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:38.0) Gecko/20100101
 Thunderbird/38.5.1
MIME-Version: 1.0
In-Reply-To: 
 <HE1PR03MB117744CA4A013014733321A4D6C70@HE1PR03MB1177.eurprd03.prod.outlook.com>
Content-Type: multipart/mixed; boundary="------------040308060000050802090205"
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

This is a multi-part message in MIME format.
--------------040308060000050802090205
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

-----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-----

--------------040308060000050802090205
Content-Type: application/pgp-keys;
 name="0x3289338C.asc"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
 filename="0x3289338C.asc"

-----BEGIN PGP PUBLIC KEY BLOCK-----
Version: GnuPG v2

mQENBFOuo7ABCADU3rFM4gBv4l/Xjfry27pfdYgvWrcR1RA/vLfOgjqivSbMQEHH
bTWprJRjB2EbzmTS+faSa/V+mH/jIKBytCc5+hprBd/m5if3/v2PKA7+MHsy1H9T
7FqTKRccNl7RIcKFOaonIbY4qMyH6cFafZOgqaGlc3ibfX7PiCL+mdl1mPoyWeVR
sKoddSobI40noE+se/FrnKZRDRWqqx7zvTRRK9vKUVDFM+Y3Kg3EDL3Qmt3MocM7
FtBZDaeyFZiKdf7bNaWM977aGwiA1gQQp+/TmB1qqSyOTzbPhxfr7G9vWdbVS2ph
80RSrxI/sF3LUNeJtTjB/jtKiG49arBqC1eDABEBAAG0Lkd1bm5hciAiTmljayIg
Qmx1dGggPGd1bm5hci5ibHV0aEBwcm8tb3Blbi5kZT6JAT8EEwECACkFAlOuo7AC
GyMFCQlmAYAHCwkIBwMCAQYVCAIJCgsEFgIDAQIeAQIXgAAKCRAQEK5rMokzjLin
CACaTXqjA7Qc6lpljpz3/5SpmPlvEDdX5mR76jN8326qkSQw7i8WBGW/5NO669OY
4ITlLbu/XL11x6hzCh7ZxMJo3fSYN+fh1tfEnNGw0NjUoy1JdBB+2B3beY+0LEBG
ZMm56HZC1u4qZq2drLM+sZIi6f8ML0NCh41s01SeX6hGQ609zCcFRNNk98pXOBER
a2kDi9wn1UvK1tECxCXuiO6HhPzhme/nFAxoBdBdATCl5EEnnLD+JfhSr2LShgXu
LQxJA6odvggfDVlS913rb0zDtV6s+6bfR+qmD4igBgC6Xl8ceDJpbS4ER7Uvw78n
Sa2i3Yub28FAGr+RvpFLi9PruQENBFOuo7ABCAC6E2x7GZ1LrIQMlNr2XYvCG9DB
p181PJJ95w4BwuaKmFBDHc5tE7p5S2sNfNfYNUjDzpr47lU5+85Ffqtf27gV8Ftd
rqv/d2lbH9+w6wShB9QOy11gPPdkB62o9CKwk+XInN2DJITWsgI8hk6NNzbotD27
x7x4fxQxBUE6YkHnJMziqwZ5emLFP0A2XPIDK6tw87UZNOnEaJ9kP3WOKihNOtMq
mr7+4BQQCyfj13k32219UZglnHtYaGuNmXOc0KHoFEIA2pkgeXRQShrwz4gdCaSN
FUZPAVeeWmdqAmnKKb+Sk7czft/wdtmBD0BykYRoZxQ3JlkHG7oH7wGXmi1TABEB
AAGJASUEGAECAA8FAlOuo7ACGwwFCQlmAYAACgkQEBCuazKJM4xN1wf+MPLXrQ10
LBRtYjD16LsvxDyEcSMoWGc26DO/TDsGwme2NVfL0JufExgdpvkk/x4wzBwdkYfF
dNKU3CyA+3T4FuKGL7RPrICJa+VdCvwMk8dzLqF0UgdfVHtCnUQoQmNnDD7gODw/
GTIKpWw+iEE2/EANAONXj7EC+VsW895/C5aQEZx++cSonrHFSSIUp1OGJoVlmFnJ
MFCTTElmayTcmfOwGHrn97Et5YePMOsyqWZas+URuJveoTdGhDToOIufECGb3WJa
J8rFL+ni3NKoiZhZMYVQ+XC8f64Mi5kXlfsylVu6kgCoFqnq7FTpwqOiRml4APeX
GBC6uZW6fUGNDQ==
=//tm
-----END PGP PUBLIC KEY BLOCK-----

--------------040308060000050802090205
Content-Type: application/octet-stream;
 name="0x3289338C.asc.sig"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
 filename="0x3289338C.asc.sig"

iQEcBAABCAAGBQJWpl/yAAoJEBAQrmsyiTOM3AsH/RRTOk5IZa50UF26S1iz
VCD46AK51bbVaTPbUWTVC71TIKwHRX3Nx6ACLkpZd0EqAPrNjG24ih4FIJPw
lXbWawOF8ounc0TJAjzPc2ysbvG2fOrpsqxIdzf2aCLKIbAEbMRcCc5No62r
+Dnowt55x50fsj0KUNvfxijt6B6bGFiqI4ktYadzFj9iIeLEoI1jFVP17gOF
ErWY8RoxKhTmbg7XcLFy88bBzXafnOurJQ5m2tJnaOuFbvRvyDicHRAxzxDr
m3E3nHx9tc4uIB79laFWUM7Mws6yx+wtaBnlakeuKQw2rmpnJG87JI724kaU
Zvf6up5sdLw6rxdG8Dt+NBg=

--------------040308060000050802090205
Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

--------------040308060000050802090205--