<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial,helvetica,sans-serif;font-size:10pt"><div>Newer versions of Postgres do not automatically create an OID column, as it was a limited 32-bit construct.<br><br>Try add "using unique XXX" where XXX is the column name of the primary key (or at least a unique key). If you've uploaded the layer from a shapefile using ogr2ogr you can use the column "ogc_fid"<br></div><div style="font-family: arial,helvetica,sans-serif; font-size: 10pt;"><br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><font face="Tahoma" size="2"><hr size="1"><b><span style="font-weight: bold;">From:</span></b> Venkat Rao Tammineni <vtammineni@roulacglobal.com><br><b><span style="font-weight: bold;">To:</span></b> Saka Royban <srph124@yahoo.com>; MapServer <mapserver-users@lists.osgeo.org><br><b><span style="font-weight:
bold;">Sent:</span></b> Thursday, January 15, 2009 5:33:35 AM<br><b><span style="font-weight: bold;">Subject:</span></b> RE: [mapserver-users] newbie: Error in first atttempt to use postgis with mapserver?<br></font><br>
<style>
<!--
_filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}
_filtered {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}
_filtered {font-family:Verdana;panose-1:2 11 6 4 3 5 4 4 2 4;}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman", "serif";}
h3
{margin-right:0in;margin-left:0in;font-size:13.5pt;font-family:"Times New Roman", "serif";font-weight:bold;}
a:link, span.MsoHyperlink
{color:blue;text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
p
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
span.Heading3Char
{font-family:"Cambria", "serif";color:#4F81BD;font-weight:bold;}
p.yui-overlay, li.yui-overlay, div.yui-overlay
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.yui-tt, li.yui-tt, div.yui-tt
{margin-right:0in;margin-left:0in;background:#FDFFB4;border:none;padding:0in;font-size:12.0pt;}
p.mask, li.mask, div.mask
{margin-right:0in;margin-left:0in;background:#CCCCCC;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.yui-panel-container, li.yui-panel-container, div.yui-panel-container
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.yui-panel, li.yui-panel, div.yui-panel
{margin-right:0in;margin-left:0in;background:white;border:none;padding:0in;font-size:12.0pt;}
p.lwembed, li.lwembed, div.lwembed
{margin-right:0in;margin-left:0in;background:white;border:none;padding:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.hd, li.hd, div.hd
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.bd, li.bd, div.bd
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.container-close, li.container-close, div.container-close
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.ft, li.ft, div.ft
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.y-livewords, li.y-livewords, div.y-livewords
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.cnrr, li.cnrr, div.cnrr
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.cnrl, li.cnrl, div.cnrl
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.yui-icon, li.yui-icon, div.yui-icon
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.dot, li.dot, div.dot
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.hdr, li.hdr, div.hdr
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.lnk, li.lnk, div.lnk
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.ylwsearch, li.ylwsearch, div.ylwsearch
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.ylwsearchbutton, li.ylwsearchbutton, div.ylwsearchbutton
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.title, li.title, div.title
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.hdl, li.hdl, div.hdl
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.sponsor, li.sponsor, div.sponsor
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.ddimagec, li.ddimagec, div.ddimagec
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.ddimageh, li.ddimageh, div.ddimageh
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.ddimagef, li.ddimagef, div.ddimagef
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.ddimageg, li.ddimageg, div.ddimageg
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.ddtextl, li.ddtextl, div.ddtextl
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.ddtextr, li.ddtextr, div.ddtextr
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.ddtitle, li.ddtitle, div.ddtitle
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.dddesc, li.dddesc, div.dddesc
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.ddurl, li.ddurl, div.ddurl
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.right, li.right, div.right
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.prev, li.prev, div.prev
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.lwprev, li.lwprev, div.lwprev
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.lwprevhover, li.lwprevhover, div.lwprevhover
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.mods, li.mods, div.mods
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.cnr, li.cnr, div.cnr
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.cnrtl, li.cnrtl, div.cnrtl
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.cnrtr, li.cnrtr, div.cnrtr
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.cnrbl, li.cnrbl, div.cnrbl
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.cnrbr, li.cnrbr, div.cnrbr
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.lwhelp, li.lwhelp, div.lwhelp
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.lwclose, li.lwclose, div.lwclose
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.lwoption, li.lwoption, div.lwoption
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.lwicns, li.lwicns, div.lwicns
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.mid, li.mid, div.mid
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.bdl, li.bdl, div.bdl
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.bdr, li.bdr, div.bdr
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.ftl, li.ftl, div.ftl
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.ftr, li.ftr, div.ftr
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
span.blckicon
{}
span.alrticon
{}
span.hlpicon
{}
span.infoicon
{}
span.warnicon
{}
span.tipicon
{}
span.selected
{}
p.hd1, li.hd1, div.hd1
{margin-right:0in;margin-left:0in;background:#3D77CB;border:none;padding:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";color:white;font-weight:bold;}
p.bd1, li.bd1, div.bd1
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.container-close1, li.container-close1, div.container-close1
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.ft1, li.ft1, div.ft1
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.yui-icon1, li.yui-icon1, div.yui-icon1
{margin-right:7.5pt;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
span.blckicon1
{}
span.alrticon1
{}
span.hlpicon1
{}
span.infoicon1
{}
span.warnicon1
{}
span.tipicon1
{}
p.ft2, li.ft2, div.ft2
{margin-right:0in;margin-left:0in;text-align:right;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.ft3, li.ft3, div.ft3
{margin-right:0in;margin-left:0in;text-align:right;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.ft4, li.ft4, div.ft4
{margin-right:0in;margin-left:0in;line-height:3.75pt;font-size:3.0pt;font-family:"Times New Roman", "serif";color:white;}
p.hd2, li.hd2, div.hd2
{margin-right:4.5pt;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.bd2, li.bd2, div.bd2
{margin-right:0in;margin-left:0in;background:#F3F4F3;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.right1, li.right1, div.right1
{margin-right:0in;margin-left:.75pt;background:#F3F4F3;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.prev1, li.prev1, div.prev1
{margin-top:0in;margin-right:5.25pt;margin-bottom:0in;margin-left:3.75pt;margin-bottom:.0001pt;background:white;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.lwprev1, li.lwprev1, div.lwprev1
{margin-right:0in;margin-left:0in;border:none;padding:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.lwprevhover1, li.lwprevhover1, div.lwprevhover1
{margin-right:0in;margin-left:0in;border:none;padding:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.mods1, li.mods1, div.mods1
{margin-top:0in;margin-right:4.5pt;margin-bottom:0in;margin-left:4.5pt;margin-bottom:.0001pt;text-align:center;font-size:7.5pt;font-family:"Times New Roman", "serif";color:#AAAAAA;}
p.title1, li.title1, div.title1
{margin-right:0in;margin-bottom:3.0pt;margin-left:0in;font-size:8.5pt;font-family:"Verdana", "sans-serif";}
p.cnr1, li.cnr1, div.cnr1
{margin:0in;margin-bottom:.0001pt;background:#F3F4F3;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.cnrtl1, li.cnrtl1, div.cnrtl1
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.cnrtr1, li.cnrtr1, div.cnrtr1
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.cnrbl1, li.cnrbl1, div.cnrbl1
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.cnrbr1, li.cnrbr1, div.cnrbr1
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.dot1, li.dot1, div.dot1
{margin-right:0in;margin-left:0in;background:#BAB8B8;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.hd3, li.hd3, div.hd3
{margin-right:0in;margin-left:0in;font-size:8.5pt;font-family:"Arial", "sans-serif";color:black;}
p.hdl1, li.hdl1, div.hdl1
{margin-right:7.5pt;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.hdr1, li.hdr1, div.hdr1
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.lwhelp1, li.lwhelp1, div.lwhelp1
{margin-right:3.75pt;margin-left:0in;border:none;padding:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.lwclose1, li.lwclose1, div.lwclose1
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.lwoption1, li.lwoption1, div.lwoption1
{margin-right:3.75pt;margin-left:0in;border:none;padding:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.lwhelp2, li.lwhelp2, div.lwhelp2
{margin-right:3.75pt;margin-left:0in;border:none;padding:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.lwclose2, li.lwclose2, div.lwclose2
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.lwoption2, li.lwoption2, div.lwoption2
{margin-right:3.75pt;margin-left:0in;border:none;padding:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.lwicns1, li.lwicns1, div.lwicns1
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.lwicns2, li.lwicns2, div.lwicns2
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.lwoption3, li.lwoption3, div.lwoption3
{margin-right:3.75pt;margin-left:0in;border:none;padding:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.lwoption4, li.lwoption4, div.lwoption4
{margin-right:3.75pt;margin-left:0in;border:none;padding:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.lwhelp3, li.lwhelp3, div.lwhelp3
{margin-right:3.75pt;margin-left:0in;border:none;padding:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.lwhelp4, li.lwhelp4, div.lwhelp4
{margin-right:3.75pt;margin-left:0in;border:none;padding:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.lwclose3, li.lwclose3, div.lwclose3
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.lwclose4, li.lwclose4, div.lwclose4
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.mid1, li.mid1, div.mid1
{margin-right:0in;margin-left:0in;background:#DFDFDF;font-size:8.5pt;font-family:"Arial", "sans-serif";color:#333333;}
p.hdl2, li.hdl2, div.hdl2
{margin-right:7.5pt;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.hdr2, li.hdr2, div.hdr2
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.ftl1, li.ftl1, div.ftl1
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.ftr1, li.ftr1, div.ftr1
{margin-right:0in;margin-left:5.25pt;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.bdl1, li.bdl1, div.bdl1
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.bdr1, li.bdr1, div.bdr1
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.hd4, li.hd4, div.hd4
{margin-right:0in;margin-left:0in;background:#E9E7E8;font-size:8.5pt;font-family:"Arial", "sans-serif";color:black;}
p.ft5, li.ft5, div.ft5
{margin-right:0in;margin-left:0in;background:white;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.hdl3, li.hdl3, div.hdl3
{margin-right:7.5pt;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.hdr3, li.hdr3, div.hdr3
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.ftl2, li.ftl2, div.ftl2
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.ftr2, li.ftr2, div.ftr2
{margin-right:0in;margin-left:5.25pt;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.bdl2, li.bdl2, div.bdl2
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.bdr2, li.bdr2, div.bdr2
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.hd5, li.hd5, div.hd5
{margin-right:0in;margin-left:0in;background:white;font-size:8.5pt;font-family:"Arial", "sans-serif";color:black;}
p.bd3, li.bd3, div.bd3
{margin:0in;margin-bottom:.0001pt;line-height:12.0pt;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.bdl3, li.bdl3, div.bdl3
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.bdr3, li.bdr3, div.bdr3
{margin-right:0in;margin-left:.75pt;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.ft6, li.ft6, div.ft6
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.mid2, li.mid2, div.mid2
{margin-top:0in;margin-right:11.25pt;margin-bottom:0in;margin-left:11.25pt;margin-bottom:.0001pt;background:gainsboro;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.ftl3, li.ftl3, div.ftl3
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.ftr3, li.ftr3, div.ftr3
{margin-right:0in;margin-left:5.25pt;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.bd4, li.bd4, div.bd4
{margin-right:0in;margin-left:0in;background:white;border:none;padding:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.bd5, li.bd5, div.bd5
{margin:0in;margin-bottom:.0001pt;background:white;font-size:12.0pt;font-family:"Times New Roman", "serif";color:black;}
p.hd6, li.hd6, div.hd6
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman", "serif";color:black;}
p.bd6, li.bd6, div.bd6
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman", "serif";}
span.selected1
{color:black;border:solid #C5C1C3 1.0pt;padding:2.0pt;background:white;text-decoration:none none;}
span.selected2
{color:black;border:solid #C5C1C3 1.0pt;padding:2.0pt;background:white;text-decoration:none none;}
p.sponsor1, li.sponsor1, div.sponsor1
{margin-top:0in;margin-right:8.25pt;margin-bottom:0in;margin-left:6.0pt;margin-bottom:.0001pt;line-height:9.0pt;border:none;padding:0in;font-size:7.5pt;font-family:"Arial", "sans-serif";color:#999999;}
p.ddimagec1, li.ddimagec1, div.ddimagec1
{margin-right:3.75pt;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.ddimageh1, li.ddimageh1, div.ddimageh1
{margin-right:3.75pt;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.ddimagef1, li.ddimagef1, div.ddimagef1
{margin-right:0in;margin-left:3.75pt;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.ddimageg1, li.ddimageg1, div.ddimageg1
{margin-right:0in;margin-left:3.75pt;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.ddtextl1, li.ddtextl1, div.ddtextl1
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.ddtextr1, li.ddtextr1, div.ddtextr1
{margin-right:0in;margin-left:0in;text-align:right;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.ddtitle1, li.ddtitle1, div.ddtitle1
{margin-right:0in;margin-left:0in;font-size:9.0pt;font-family:"Arial", "sans-serif";color:#0E46B3;}
p.dddesc1, li.dddesc1, div.dddesc1
{margin-right:0in;margin-left:0in;font-size:7.5pt;font-family:"Arial", "sans-serif";color:#999999;}
p.ddurl1, li.ddurl1, div.ddurl1
{margin-right:0in;margin-left:0in;font-size:7.5pt;font-family:"Arial", "sans-serif";color:#0C8013;}
p.ft7, li.ft7, div.ft7
{margin-right:0in;margin-left:0in;border:none;padding:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.cnrr1, li.cnrr1, div.cnrr1
{margin:0in;margin-bottom:.0001pt;line-height:0%;background:white;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.cnrl1, li.cnrl1, div.cnrl1
{margin:0in;margin-bottom:.0001pt;line-height:0%;background:white;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.cnrl2, li.cnrl2, div.cnrl2
{margin:0in;margin-bottom:.0001pt;line-height:0%;background:white;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.cnrr2, li.cnrr2, div.cnrr2
{margin:0in;margin-bottom:.0001pt;line-height:0%;background:white;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.cnrl3, li.cnrl3, div.cnrl3
{margin:0in;margin-bottom:.0001pt;line-height:0%;background:white;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.cnrr3, li.cnrr3, div.cnrr3
{margin:0in;margin-bottom:.0001pt;line-height:0%;background:white;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.dot2, li.dot2, div.dot2
{margin-right:0in;margin-left:0in;background:#E5E5E5;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.dot3, li.dot3, div.dot3
{margin-right:0in;margin-left:0in;background:#E5E5E5;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.hdr4, li.hdr4, div.hdr4
{margin-top:3.0pt;margin-right:4.5pt;margin-bottom:3.75pt;margin-left:4.5pt;border:none;padding:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.lnk1, li.lnk1, div.lnk1
{margin-right:0in;margin-left:0in;font-size:7.5pt;font-family:"Verdana", "sans-serif";}
p.bd7, li.bd7, div.bd7
{margin-top:0in;margin-right:4.5pt;margin-bottom:0in;margin-left:4.5pt;margin-bottom:.0001pt;text-align:center;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.ylwsearch1, li.ylwsearch1, div.ylwsearch1
{margin-top:0in;margin-right:3.0pt;margin-bottom:0in;margin-left:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman", "serif";}
p.ylwsearchbutton1, li.ylwsearchbutton1, div.ylwsearchbutton1
{margin:0in;margin-bottom:.0001pt;font-size:8.5pt;font-family:"Arial", "sans-serif";}
span.yshortcuts
{}
span.EmailStyle177
{font-family:"Calibri", "sans-serif";color:#1F497D;}
.MsoChpDefault
{font-size:10.0pt;}
_filtered {margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{}
-->
</style>
<div class="Section1">
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);">Hi,</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);"> I think OID column may not be with your table…Can
you check that ..</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);">Thanks</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);">Venkat.</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125);"> </span></p>
<div>
<div style="border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0in 0in;">
<p class="MsoNormal"><b><span style="font-size: 10pt; font-family: "Tahoma","sans-serif";">From:</span></b><span style="font-size: 10pt; font-family: "Tahoma","sans-serif";">
mapserver-users-bounces@lists.osgeo.org
[mailto:mapserver-users-bounces@lists.osgeo.org] <b>On Behalf Of </b>Saka
Royban<br>
<b>Sent:</b> Thursday, January 15, 2009 3:36 PM<br>
<b>To:</b> MapServer<br>
<b>Subject:</b> [mapserver-users] newbie: Error in first atttempt to use
postgis with mapserver?</span></p>
</div>
</div>
<p class="MsoNormal"> </p>
<div>
<div>
<div>
<div>
<p class="MsoNormal">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:
ERROR: column "oid" does not exist LINE 1:
...inary(force_collection(force_2d(the_geom)),'NDR'),OID::text ... ^ With <span class="yshortcuts">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">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</p>
</div>
</div>
<p class="MsoNormal"><br>
<br>
</p>
<div>
<p class="MsoNormal"><br>
<br>
-----Inline Attachment Follows-----<br>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a rel="nofollow" ymailto="mailto:postgis-users@postgis.refractions.net" target="_blank" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a rel="nofollow" target="_blank" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a></p>
</div>
</div>
</div>
<p class="MsoNormal"> </p>
</div>
</div></div></div><br>
</body></html>