<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1276" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=716373620-22012004><FONT face=Arial color=#0000ff size=2>Hi
Danny</FONT></SPAN></DIV>
<DIV><SPAN class=716373620-22012004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=716373620-22012004><FONT face=Arial color=#0000ff size=2>I
don't nkow if it could be a great help for you.</FONT></SPAN></DIV>
<DIV><SPAN class=716373620-22012004><FONT face=Arial color=#0000ff
size=2>However you can have a glance at the script I used to install postgis
0.8.1 + postgresql 7.4 :</FONT></SPAN></DIV>
<DIV><SPAN class=716373620-22012004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=716373620-22012004><FONT face=Arial color=#0000ff size=2><A
href="http://techer.pascal.free.fr/postgis/installation_script.htm">http://techer.pascal.free.fr/postgis/installation_script.htm</A></FONT></SPAN></DIV>
<DIV><SPAN class=716373620-22012004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=716373620-22012004><FONT face=Arial color=#0000ff size=2>it's
french but don't matter about that. :)</FONT></SPAN></DIV>
<DIV><SPAN class=716373620-22012004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=716373620-22012004><FONT face=Arial color=#0000ff size=2>In
short, the versions I used are sumarized in the table</FONT></SPAN></DIV>
<DIV><SPAN class=716373620-22012004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=716373620-22012004><FONT face=Arial color=#0000ff size=2>and
you see the script (install.sh) after in the page.</FONT></SPAN></DIV>
<DIV><SPAN class=716373620-22012004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=716373620-22012004><FONT face=Arial color=#0000ff size=2>Maybe
a comparaison could be a great help. </FONT></SPAN></DIV>
<DIV><SPAN class=716373620-22012004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=716373620-22012004><FONT face=Arial color=#0000ff size=2>That's
all I could do.</FONT></SPAN></DIV>
<DIV><SPAN class=716373620-22012004><FONT face=Arial color=#0000ff size=2>I
installed PostGIS 0.8.0 on Windows with cygwin( emulator Linux) but the way of
installation is the same</FONT></SPAN></DIV>
<P><FONT size=2>TECHER Jean David<BR>Tél: 06-85-37-36-75<BR>e-mail:
davidtecher@yahoo.fr<BR>Site PostGIS: <A
href="http://techer.pascal.free.fr/postgis/index.htm"
target=_blank>http://techer.pascal.free.fr/postgis/index.htm</A><BR></FONT></P>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Message d'origine-----<BR><B>De :</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net]<B>De la part de</B>
postgis@dannykent.com<BR><B>Envoyé :</B> jeudi 22 janvier 2004
21:28<BR><B>À :</B>
postgis-users@postgis.refractions.net<BR><B>Objet :</B> [postgis-users]
Re: postgis.sql error<BR><BR></FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #5167c6 2px solid; MARGIN-RIGHT: 0px">Thanks
for the replies to my postgis.sql issue. Still looking for a
solution.<BR><BR><BR><EM>Did you put USE_GEOS=1 when you compiled
postgis?<BR></EM>No I compiled PostGIS with USE_GEOS = 0.<BR><BR><EM>Danny,
could you tell us more about your setup? Did you compile
postgresql<BR>yourself or are you using a stock version? I assume you're on
some *nix<BR>operating system. Are you sure that the postgis.sql that you
are loading<BR>is from the same version of the postgis libraries you
installed?<BR></EM><BR>I am installing on RH 8.0. I downloaded and installed
Postgres 0.7.4.1 from the source. I am also using PostGIS 0.8. I am sure
these are from the same packages b/c this is being done on a fresh partition
with nothing else installed.<BR><BR>Thanks for the help, hopefully we
can find the issue.<BR><BR>~Danny</BLOCKQUOTE><BR></BLOCKQUOTE></BODY></HTML>