Dear Regina,<br><br>I tried the second solution and now it works perfectly!<br>I found your guide really useful.<br><br>Thank you very much for your help,<br>-Elena <br><br><div><span class="gmail_quote">On 8/3/07, <b class="gmail_sendername">
Obe, Regina</b> <<a href="mailto:robe.dnd@cityofboston.gov">robe.dnd@cityofboston.gov</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">It sounds like you probably don't have the postgis
functions installed in the database you are working with. You have one of
2 ways of doing this.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">1) If you haven't done much, you can simply drop your
current database, and create a new database using the template_postgis database
template.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">2) If you have stuff already run the following file in your
current db that should be located in your</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">Program
Files\PostgreSQL\8.2\share\contrib\lwpostgis.sql and <font color="#000000" face="Times New Roman" size="3">\share\contrib\spatial_ref_sys.sql</font></font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">The details are pretty much documented here.
</font></span><span><font color="#0000ff" face="Arial" size="2"></font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"><a href="http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01</a></font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">Sorry haven't had a chance to completely update the doc
above.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">To find out which version you are running, you can run the
below command</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">select postgis_full_version()</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">If you are running a version than 1.2.1, you might want to
upgrade to the newest using</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"><a href="http://postgis.refractions.net/download/windows/" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://postgis.refractions.net/download/windows/
</a></font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">Hope that helps,</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">Regina</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div><br>
<div dir="ltr" align="left" lang="en-us">
<hr>
<font face="Tahoma" size="2"><b>From:</b>
<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">postgis-users-bounces@postgis.refractions.net</a>
[mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">postgis-users-bounces@postgis.refractions.net</a>] <b>On Behalf Of </b>Elena
Camossi<br><b>Sent:</b> Friday, August 03, 2007 5:57 AM<br><b>To:</b> PostGIS
Users Discussion<br><b>Subject:</b> [postgis-users] AddGeometryColumn does not
exist<br></font><br></div><div><span class="e" id="q_1142b80e0be6d384_1">
<div></div>Hi all,<br><br>I'm new to PostGis, and I'm making some preliminary
test following the manual.<br>With this command:<br><br> select
AddGeometryColumn('', 'gtest', 'geom', -1, 'LINESTRING', 2); <br><br>I got this
error:<br><br>ERROR: function addgeometrycolumn("unknown", "unknown", "unknown",
integer, "unknown", integer) does not exist<br>SQL state: 42883<br>Hint: No
function matches the given name and argument types. You may need to add explicit
type casts. <br>Character: 8<br><br>I'm running Postgres 8.2 with PostGIS
enabled on Windows XP.<br><br>Thank you for any helping.<br><br>Best
Regards,<br>-Elena <br><br><br></span></div></div>
<div><p></p><hr size="1"><p></p>
<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></p></div><br>_______________________________________________<br>postgis-users mailing list<br><a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net
</a><br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br><br>
</blockquote></div><br>