<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<STYLE type=text/css>DIV {
MARGIN: 0px
}
</STYLE>
<META content="MSHTML 6.00.6000.16788" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=672134110-15012009>You don't have a column "oid" in your table. May be
this is because OIDs are disabled. I assume you (or the workshop) tries to use
something like "...USING UNIQUE oid..." in the DATA
definition.</SPAN></FONT></DIV>
<DIV class=OutlookMessageHeader lang=de dir=ltr align=left><SPAN
class=672134110-15012009><FONT face=Arial color=#0000ff size=2>You can create a
integer column in the table, fill it with a sequence and use that in the DATA
definition in your map file. For example:</FONT></SPAN></DIV>
<DIV class=OutlookMessageHeader lang=de dir=ltr align=left><SPAN
class=672134110-15012009><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV class=OutlookMessageHeader lang=de dir=ltr align=left><SPAN
class=672134110-15012009><FONT face=Arial color=#0000ff
size=2>BEGIN;</FONT></SPAN></DIV>
<DIV class=OutlookMessageHeader lang=de dir=ltr align=left><SPAN
class=672134110-15012009><FONT face=Arial size=2><FONT color=#0000ff>ALTER TABLE
<FONT face="Times New Roman" size=3>bc_municipality ADD
id;</FONT></FONT></FONT></SPAN></DIV>
<DIV class=OutlookMessageHeader lang=de dir=ltr align=left><SPAN
class=672134110-15012009><FONT color=#0000ff>CREATE SEQUENCE
bc_municipality_id_seq OWNED BY bc_municipality.id;</FONT></SPAN></DIV>
<DIV class=OutlookMessageHeader lang=de dir=ltr align=left><SPAN
class=672134110-15012009><FONT color=#0000ff>UPDATE bc_municipality SET id =
nextval('bc_municipality_id_seq'::regclass);</FONT></SPAN></DIV>
<DIV class=OutlookMessageHeader lang=de dir=ltr align=left><SPAN
class=672134110-15012009><FONT color=#0000ff>COMMIT;</FONT></SPAN></DIV>
<DIV class=OutlookMessageHeader lang=de dir=ltr align=left><SPAN
class=672134110-15012009> </SPAN></DIV>
<DIV class=OutlookMessageHeader lang=de dir=ltr align=left>
<HR tabIndex=-1>
</DIV>
<DIV class=OutlookMessageHeader lang=de dir=ltr align=left><FONT face=Tahoma
size=2><B>Von:</B> mapserver-users-bounces@lists.osgeo.org
[mailto:mapserver-users-bounces@lists.osgeo.org] <B>Im Auftrag von </B>Saka
Royban<BR><B>Gesendet:</B> Donnerstag, 15. Januar 2009 11:06<BR><B>An:</B>
MapServer<BR><B>Betreff:</B> [mapserver-users] newbie: Error in first atttempt
to use postgiswith mapserver?<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman,new york,times,serif">
<DIV>
<SCRIPT defer type=text/javascript>var YAHOO = {'Shortcuts' : {}};
if (typeof YAHOO == "undefined") {
var YAHOO = {};
}
YAHOO.Shortcuts = YAHOO.Shortcuts || {};
YAHOO.Shortcuts.hasSensitiveText = false;
YAHOO.Shortcuts.sensitivityType = [];
YAHOO.Shortcuts.doUlt = false;
YAHOO.Shortcuts.location = "us";
YAHOO.Shortcuts.document_id = 0;
YAHOO.Shortcuts.document_type = "";
YAHOO.Shortcuts.document_title = "[postgis-users] newbie: Error in first atttempt to use postgis with mapserver?";
YAHOO.Shortcuts.document_publish_date = "";
YAHOO.Shortcuts.document_author = "srph124@yahoo.com";
YAHOO.Shortcuts.document_url = "";
YAHOO.Shortcuts.document_tags = "";
YAHOO.Shortcuts.document_language = "english";
YAHOO.Shortcuts.annotationSet = {
"lw_1232013652_0": {
"text": "query string",
"extended": 0,
"startchar": 645,
"endchar": 656,
"start": 645,
"end": 656,
"extendedFrom": "",
"predictedCategory": "",
"predictionProbability": "0",
"weight": 0.393738,
"relScore": 6.17683,
"type": ["shortcuts:/concept"],
"category": ["CONCEPT"],
"wikiId": "Query_string",
"relatedWikiIds": [],
"relatedEntities": [],
"showOnClick": [],
"context": "ERROR: column \u0022oid\u0022 does not exist LINE 1: ...inary(force_collection(force_2d(the_geom)),\u0027NDR\u0027),OID::text ... ^ With query string: DECLARE mycursor BINARY CURSOR FOR SELECT asbinary(force_collection(force_2d(the_geom)),\u0027NDR\u0027),OID::text from bc_municipality WHERE",
"metaData": {
"visible": "true"
}
},
"lw_1232013652_1": {
"text": "497368421",
"extended": 0,
"startchar": 854,
"endchar": 862,
"start": 854,
"end": 862,
"extendedFrom": "",
"predictedCategory": "",
"predictionProbability": "0",
"weight": 1,
"relScore": 0,
"type": ["shortcuts:/us/instance/identifier/ups_tracking"],
"category": ["IDENTIFIER"],
"wikiId": "",
"relatedWikiIds": [],
"relatedEntities": [],
"showOnClick": [],
"context": "",
"metaData": {
"verified": "false",
"visible": "true"
}
}
};
YAHOO.Shortcuts.headerID = "9170a5ad7850b6327592e7202c387997";
</SCRIPT>
<STYLE type=text/css>DIV {
MARGIN: 0px
}
</STYLE>
<LINK media=all href="http://d.yimg.com/jq/css/contextual_shortcuts.css"
type=text/css rel=stylesheet>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman,new york,times,serif">
<DIV>Hi everyone.<BR>i've used workshop material of FOSS4G2007 (PostGIS
workshop)to learn postgis along with its data. but there is a problem<BR>i got
this error in first attempt to retrieve data from postgis:<BR><BR>msDrawMap():
Image handling error. Failed to draw layer named 'bc_municipality'.
prepare_database(): Query error. Error declaring cursor: <FONT
color=#ff0000>ERROR: column "oid" does not exist</FONT> LINE 1:
...inary(force_collection(force_2d(the_geom)),'NDR'),OID::text ... ^ With <SPAN
class=yshortcuts id=lw_1232013652_0
style="CURSOR: pointer; BORDER-BOTTOM: rgb(0,102,204) 1px dashed">query
string</SPAN>: DECLARE mycursor BINARY CURSOR FOR SELECT
asbinary(force_collection(force_2d(the_geom)),'NDR'),OID::text from
bc_municipality WHERE the_geom && setSRID('BOX3D(458426.1 260651.<SPAN
class=yshortcuts id=lw_1232013652_1>497368421</SPAN>,1943216.4
1373313.90263158)'::BOX3D, find_srid('','bc_municipality ','the_geom') )
msPOSTGISLayerRetrievePGVersion(): Query error. Error executing POSTGIS
statement (msPOSTGISLayerRetrievePGVersion():select substring(version() from 12
for (position('on' in version()) - 13)) <BR><BR>i don't know what causes the
problem although it sounds easy.<BR>THX<BR></DIV></DIV><BR><SPAN
id=lw_beacon_1232013798031></SPAN><!-- kill -->
<DIV><BR><BR>-----Inline Attachment
Follows-----<BR><BR>_______________________________________________<BR>postgis-users
mailing list<BR><A href="mailto:postgis-users@postgis.refractions.net"
ymailto="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><BR><A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR></DIV>
<DIV class="module overlay yui-module yui-overlay" id=lwPreview
style="LEFT: -400px; POSITION: absolute; TOP: -400px">
<DIV class=hd></DIV>
<DIV class=bd></DIV>
<DIV class=ft></DIV></DIV></DIV></DIV><BR></BODY></HTML>