<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>populating a table</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16414" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=539162012-12032007><FONT face=Arial
color=#0000ff size=2>Is this a new database you are loading into? Sounds
like you are missing the addgeometrycolumn function perhaps because load of
postgis functions failed when creating the database or you didn't load
them.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=539162012-12032007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=539162012-12032007><FONT face=Arial
color=#0000ff size=2>Other possibility is that you have the addgeometrycolumn
function, but it is not in your default schema or one of your search
schemas.</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>Malm
Paul<BR><B>Sent:</B> Monday, March 12, 2007 8:13 AM<BR><B>To:</B>
postgis-users@postgis.refractions.net<BR><B>Subject:</B> [postgis-users]
populating a table<BR></FONT><BR></DIV>
<DIV></DIV><!-- Converted from text/rtf format -->
<P dir=ltr><SPAN lang=en-us></SPAN><SPAN lang=en-us><FONT face=Arial
size=2>Hi!</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-us><FONT face=Arial size=2>This has worked
before</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us><FONT face=Arial
size=2>, could anyone please tell me what</FONT></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-us><FONT face=Arial size=2>’</FONT></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-us><FONT face=Arial size=2>s
wrong?</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us></SPAN></P>
<P dir=ltr><SPAN lang=en-us></SPAN><SPAN lang=en-us><FONT face=Arial
size=2>I</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us><FONT face=Arial
size=2>’</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us><FONT face=Arial
size=2>m trying to create and populate a Table in my database with a
s</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us><FONT face=Arial
size=2>c</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us><FONT face=Arial
size=2>ript</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us> <FONT
face=Arial size=2>generated with</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us> <FONT face=Arial size=2>shp2pgsql.exe</FONT></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-us><FONT face=Arial size=2>
SQL</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us><FONT face=Arial
size=2>:</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us></SPAN></P>
<P dir=ltr><SPAN lang=en-us></SPAN><SPAN lang=en-us><FONT face=Arial
size=2>BEGIN;</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-us><FONT face=Arial size=2>CREATE TABLE
"public"."h1707640_cul_transl" (gid serial PRIMARY KEY,</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-us></SPAN><SPAN lang=en-us></SPAN><SPAN lang=sv><FONT
face=Arial size=2>"f_code" varchar(5),</FONT></SPAN></P>
<P dir=ltr><SPAN lang=sv><FONT face=Arial size=2>"f_code_des"
varchar(254),</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-us></SPAN><SPAN lang=en-us><FONT face=Arial
size=2>"exs" int2,</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-us><FONT face=Arial size=2>"exs_descri"
varchar(254),</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-us><FONT face=Arial size=2>"tile_id"
int2,</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-us><FONT face=Arial size=2>"edg_id"
int4,</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-us><FONT face=Arial size=2>"shape_leng"
numeric);</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-us><FONT face=Arial size=2>SELECT
AddGeometryColumn('public','h1707640_cul_transl','the_geom','-1','MULTILINESTRING',2);</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-us><FONT face=Arial size=2>INSERT INTO
"public"."h1707640_cul_transl"
("f_code","f_code_des","exs","exs_descri","tile_id","edg_id","shape_leng",the_geom)
VALUES
('AP030','Road','28','Operational','1','6','3.05816496139e004','01050000000100000001020000000300000084F6FF3F5A8152C0580100E0D26144402C2000C05C8152C02A2E00C0D361444007EDFF1F5F8152C055210060D2614440');</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-us></SPAN><SPAN lang=en-us><FONT face=Arial
size=2>END;</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-us></SPAN><SPAN lang=en-us></SPAN></P>
<P dir=ltr><SPAN lang=en-us></SPAN><SPAN lang=en-us><FONT face=Arial
size=2>I</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us><FONT face=Arial
size=2>’</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us><FONT face=Arial
size=2>m getting the follo</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us><FONT face=Arial size=2>w</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us><FONT face=Arial size=2>ing e</FONT></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-us><FONT face=Arial size=2>rror
message:</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-us></SPAN><SPAN lang=en-us><FONT face=Arial
size=2>NOTICE: CREATE TABLE will create implicit sequence
"h1707640_cul_transl_gid_seq" for serial column
"h1707640_cul_transl.gid"</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-us><FONT face=Arial size=2>NOTICE: CREATE TABLE /
PRIMARY KEY will create implicit index "h1707640_cul_transl_pkey" for table
"h1707640_cul_transl"</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-us><FONT face=Arial size=2>ERROR: function
addgeometrycolumn("unknown", "unknown", "unknown", "unknown", "unknown",
integer) does not exist</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-us><FONT face=Arial size=2>SQL state:
42883</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-us><FONT face=Arial size=2>Hint: No function matches
the given name and argument types. You may need to add explicit type
casts.</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-us></SPAN><SPAN lang=en-us><FONT face=Arial
size=2>Character: 225</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us></SPAN></P>
<P dir=ltr><SPAN lang=en-us></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=sv-se></SPAN><A name=""><SPAN lang=sv-se></SPAN></A></P>
<P dir=ltr><SPAN lang=en-us></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=sv-se></SPAN></P>
<P dir=ltr><SPAN lang=en-us><B></B></SPAN><SPAN
lang=en-us><B></B></SPAN><B><SPAN lang=sv-se><FONT face=Arial size=2>Paul
Malm</FONT></SPAN></B></P>
<P dir=ltr><SPAN lang=en-us></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=sv-se><FONT face=Arial size=2>Saab Systems, Naval Systems
Division</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-us></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=sv-se><FONT face=Arial size=2>Tel: +46 8 580 838 22</FONT></SPAN></P>
<P dir=ltr><SPAN lang=sv-se><FONT face=Arial size=2>Mobile: +46 734 373
822</FONT></SPAN></P>
<P dir=ltr><SPAN lang=en-us></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=sv-se></SPAN></P>
<P dir=ltr><SPAN lang=en-us></SPAN></P></BODY></HTML>
<HTML><BODY><P><hr size=1></P><br>
<P><STRONG><br>
The substance of this message, including any attachments, may be<br>
confidential, legally privileged and/or exempt from disclosure<br>
pursuant to Massachusetts law. It is intended solely for the<br>
addressee. If you received this in error, please contact the sender<br>
and delete the material from any computer.<br>
</STRONG></P></BODY></HTML>