<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16481" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=151112111-03082007><FONT face=Arial
color=#0000ff 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 class=151112111-03082007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=151112111-03082007><FONT face=Arial
color=#0000ff 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 class=151112111-03082007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=151112111-03082007><FONT face=Arial
color=#0000ff 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 class=151112111-03082007><FONT face=Arial
color=#0000ff size=2>Program
Files\PostgreSQL\8.2\share\contrib\lwpostgis.sql and <FONT
face="Times New Roman" color=#000000
size=3>\share\contrib\spatial_ref_sys.sql</FONT></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=151112111-03082007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=151112111-03082007><FONT face=Arial
color=#0000ff size=2>The details are pretty much documented here.
</FONT></SPAN><SPAN class=151112111-03082007><FONT face=Arial color=#0000ff
size=2></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=151112111-03082007><FONT face=Arial
color=#0000ff size=2><A
href="http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01">http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=151112111-03082007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=151112111-03082007><FONT face=Arial
color=#0000ff size=2>Sorry haven't had a chance to completely update the doc
above.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=151112111-03082007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=151112111-03082007><FONT face=Arial
color=#0000ff 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 class=151112111-03082007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=151112111-03082007><FONT face=Arial
color=#0000ff size=2>select postgis_full_version()</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=151112111-03082007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=151112111-03082007><FONT face=Arial
color=#0000ff 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 class=151112111-03082007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=151112111-03082007><FONT face=Arial
color=#0000ff size=2><A
href="http://postgis.refractions.net/download/windows/">http://postgis.refractions.net/download/windows/</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=151112111-03082007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=151112111-03082007><FONT face=Arial
color=#0000ff size=2>Hope that helps,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=151112111-03082007><FONT face=Arial
color=#0000ff size=2>Regina</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=151112111-03082007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=151112111-03082007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=151112111-03082007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=151112111-03082007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=151112111-03082007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <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></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></BODY></HTML>
<HTML><BODY><P><hr size=1></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></BODY></HTML>