<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<title>RE: [postgis-devel] WKT Raster: Why
havingtocompilePostgreSQL&PostGIS first?</title>
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>So I could build everything but now when I try to execute postgis.sql
in a database I get:<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>NOTICE: type "spheroid" is not yet defined<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>DETAIL: Creating a shell type definition.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>ERROR: could not load library
"C:/msys/1.0/local/pgsql/lib/postgis-1.4.dll": unknown error 126<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Any idea?<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>I compiled postgresql-8.3.6, postgis-svn, geos\trunk and proj-4.6.1<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Pierre<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
postgis-devel-bounces@postgis.refractions.net
[mailto:postgis-devel-bounces@postgis.refractions.net] <b>On Behalf Of </b>Obe,
Regina<br>
<b>Sent:</b> 2 mars 2009 12:45<br>
<b>To:</b> PostGIS Development Discussion<br>
<b>Subject:</b> RE: [postgis-devel] WKT Raster: Why
havingtocompilePostgreSQL&PostGISfirst?<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p style='margin-bottom:12.0pt'><span style='font-size:10.0pt'>Pierre,<br>
<br>
I cheated on that part as Mark said. I used my OpenSUSE VM downloaded
from <a href="http://www.go-mono.com/mono-downloads/download.html">http://www.go-mono.com/mono-downloads/download.html</a>
(which I use for .NET testing on Linux and just happened to come in handy for
postgis development as well)<br>
<br>
below to do the autogen stuff and then sftp to my windows desktop with
filezilla (though I suppose I could have used a file share, but seemed just as
easy to use sftp).<br>
<br>
Alternatively for just compiling postgis you can download from the daily svn
snapshot and pull out the configure stuff. <br>
<br>
Are we going to have an svn snapshot for WKT Raster? Would be nice if we
did.<br>
<br>
Hope that helps,<br>
Regina<br>
<br>
<br>
-----Original Message-----<br>
From: postgis-devel-bounces@postgis.refractions.net on behalf of Pierre Racine<br>
Sent: Mon 3/2/2009 11:40 AM<br>
To: PostGIS Development Discussion<br>
Subject: RE: [postgis-devel] WKT Raster: Why
havingtocompilePostgreSQL&PostGIS first?<br>
<br>
I got GEOS built. Last is PostGIS (and then WKT Raster). I get:<br>
<br>
racinep@DESROCHERSA-02 /wktrasterdevel/postgis/trunk<br>
$ ./autogen.sh<br>
/usr/share/aclocal/autoopts.m4:22: warning: underquoted definition of
AG_PATH_AUTOOPTS<br>
run info '(automake)Extending aclocal'<br>
or see <a
href="http://sources.redhat.com/automake/automake.html#Extending%20aclocal">http://sources.redhat.com/automake/automake.html#Extending%20aclocal</a><br>
<br>
Regina already had this problem (<a
href="http://www.nabble.com/Compile-issues-on-MingW-trunk-td21626492.html">http://www.nabble.com/Compile-issues-on-MingW-trunk-td21626492.html</a>)
but I don't understand the fix.<br>
<br>
Pierre<br>
<br>
>-----Original Message-----<br>
>From: postgis-devel-bounces@postgis.refractions.net [<a
href="mailto:postgis-devel-">mailto:postgis-devel-</a><br>
>bounces@postgis.refractions.net] On Behalf Of Mateusz Loskot<br>
>Sent: 2 mars 2009 10:40<br>
>To: PostGIS Development Discussion<br>
>Subject: RE: [postgis-devel] WKT Raster: Why having
tocompilePostgreSQL&PostGIS first?<br>
><br>
>Pierre Racine wrote:<br>
>> >>
---------------------------------------------------------------<br>
>> >> make[4]: Entering directory<br>
>> >> `/wktrasterdevel/postgresql-8.3.5/src/backend/access/common'
gcc -O2<br>
>> >> -Wall -Wmissing-prototypes -Wpointer-arith -Winline<br>
>> >> -Wdeclaration-after-statement -Wendif-labels
-fno-strict-aliasing<br>
>> >> -fwrapv -I../../../../src/include -I./src/include/port/win32<br>
>> >> -DEXEC_BACKEND
"-I../../../../src/include/port/win32" -<br>
>> DBUILDING_DLL<br>
>> >> -c -o printtup.o printtup.c In file included from<br>
>> >><br>
>>
c:/mingw/bin/../lib/gcc/mingw32/3.4.5/../../../../include/security.h:38<br>
>> ,<br>
>> >> from ../../../../src/include/libpq/libpq-be.h:50, from<br>
>> >> ../../../../src/include/libpq/libpq.h:21, from printtup.c:19:<br>
>> >>
c:/mingw/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sspi.h:60:<br>
>> >> error: syntax error before "SECURITY_STRING"<br>
>> ><br>
>> >Googling for the error message confirms this is a known bug and
small<br>
>> >fix is explained here:<br>
>> ><br>
>> ><a
href="http://archives.postgresql.org/pgsql-bugs/2009-02/msg00092.php">http://archives.postgresql.org/pgsql-bugs/2009-02/msg00092.php</a><br>
>><br>
>> Thanks. However if I can live with a released version of PostgreSQL,<br>
>> I'll be happy.<br>
>><br>
>> >> So following your suggestion that "There is no need to
build<br>
>> >> PostgreSQL" I installed 8.3.6...<br>
>> >><br>
>> >> Can I compile Geos with gcc? Or I have to use VC?<br>
>> ><br>
>> >GEOS can be build with both. However, I have no idea if you can
safely<br>
>> >mix binaries built with MinGW and Visual C++.<br>
>> ><br>
>> >> ./configure doesn't seems to be an option.<br>
>> ><br>
>> >Why?<br>
>><br>
>> racinep@DESROCHERSA-02 /wktrasterdevel/geos/trunk<br>
>> $ ./configure<br>
>> sh: ./configure: No such file or directory<br>
>><br>
>> racinep@DESROCHERSA-02 /wktrasterdevel/geos/trunk<br>
>> $ autogen<br>
>><br>
>> Autogen hang without doing anything...<br>
><br>
>You can't use autogen.bat script which is dedicated to bootstrapping for
Visual C++.<br>
>You need to use autotools-dedicated one:<br>
><br>
>$ ./autogen.sh<br>
><br>
>Here it is explained:<br>
><br>
><a href="http://trac.osgeo.org/geos/#BuildandInstall">http://trac.osgeo.org/geos/#BuildandInstall</a><br>
><br>
>Mateusz</span><o:p></o:p></p>
<div class=MsoNormal align=center style='text-align:center'>
<hr size=1 width="100%" align=center>
</div>
<p><strong>The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure pursuant to
Massachusetts law. It is intended solely for the addressee. If you received
this in error, please contact the sender and delete the material from any
computer. </strong><o:p></o:p></p>
<div class=MsoNormal align=center style='text-align:center'>
<hr size=1 width="100%" align=center>
</div>
<p><strong><span style='font-size:10.0pt;color:#339900'>Help make the earth a
greener place. If at all possible resist printing this email and join us in
saving paper. <o:p></o:p></span></strong></p>
</div>
</body>
</html>