<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18904">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2>Hi</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>please check if you have an "oid" column in your table in
postgres.</FONT></DIV>
<DIV><FONT size=2>otherwise, you may try to you add a "using unique" in
your data string specifing the column id to use for unique
identifiant.</FONT></DIV>
<DIV><FONT size=2>edit the mapfile and look for the layers EDITPOLY, EDITLINE
and EDITPOINT and add the corresponding strings:</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>"using unique parc_id" for EDITPOLY</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>"using unique id" for EDITLINE and EDITPOINT</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>like this:</FONT></DIV>
<DIV><FONT size=2>DATA 'the_geom from (select the_geom, oid, parc_id, name,
culture, surf, parc_type from edit_poly) as foo using unique
parc_id'</FONT></DIV>
<DIV><FONT size=2>DATA 'the_geom from (select the_geom, oid, id, name, length
from edit_line) as foo using unique id'</FONT></DIV>
<DIV><FONT size=2>DATA 'the_geom from (select the_geom, oid, id, name, surname,
place, age from edit_point) as foo using unique id'</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>you may also have to add "using SRID=the_data_projection" if
the data projection is different from your mapfile projection</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>regards</FONT></DIV>
<DIV><FONT size=2>Oliver</FONT></DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="FONT: 10pt arial; BACKGROUND: #e4e4e4; font-color: black"><B>From:</B>
<A title=ramkumaracharyulu@gmail.com
href="mailto:ramkumaracharyulu@gmail.com">Ramkumar Acharyulu</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=cartoweb-users@lists.maptools.org
href="mailto:cartoweb-users@lists.maptools.org">cartoweb-users@lists.maptools.org</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, April 27, 2010 7:57
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [Cartoweb-users] error
configuring demoEdit plugin</DIV>
<DIV><BR></DIV>Dear Bruno,<BR><BR>I had a similar problem as reported by jefe,
as i used CW3.5 with PostGRE8.4/PostGIS 1.5.1.<BR><BR>Noting from your reply i
downgraded to PostGRE8.3 and PostGIS1.3.5. But the problem still
remains.<BR>Could you please immediately help me as i need to complete a
project in time.<BR><BR>Let me repeat the error content:<BR><BR clear=all><PRE>FailureCartoWeb version: 3.5.0 [$Revision: 1.9 $]<BR>> class: SoapFaultWrapper<BR>> message: MapServer error: Error in msPOSTGISLayerRetrievePGVersion(): Error <BR>
> executing POSTGIS statement (msPOSTGISLayerRetrievePGVersion():select <BR>> substring(version() from 12 for (position('on' in version()) - 13))<BR>> <BR>> Error in msPOSTGISLayerRetrievePGVersion(): Error executing POSTGIS statement <BR>
> (msPOSTGISLayerRetrievePGVersion():select substring(version() from 12 for <BR>> (position('on' in version()) - 13))<BR>> <BR>> Error in msPOSTGISLayerRetrievePGVersion(): Error executing POSTGIS statement <BR>
> (msPOSTGISLayerRetrievePGVersion():select substring(version() from 12 for <BR>> (position('on' in version()) - 13))<BR>> <BR>> <BR>> Backtrace:<BR>> <BR>> file: 230 - C:\ms4w\apps\cartoweb3\coreplugins\images\server\ServerImages.php<BR>
> call: ServerContext->checkMsErrors()<BR>> <BR>> file: 311 - C:\ms4w\apps\cartoweb3\server\Cartoserver.php<BR>> call: ServerImages->drawMainmap(Object(Images))<BR>> <BR>> file: 349 - C:\ms4w\apps\cartoweb3\server\Cartoserver.php<BR>
> call: Cartoserver->doGetMap(Object(MapRequest))<BR>> <BR>> file: 370 - C:\ms4w\apps\cartoweb3\server\Cartoserver.php</PRE><BR>--
<BR>N. Ram kumar Acharyulu<BR>
<P>
<HR>
<P></P>_______________________________________________<BR>Cartoweb-users
mailing
list<BR>Cartoweb-users@lists.maptools.org<BR>http://lists.maptools.org/mailman/listinfo/cartoweb-users<BR></BLOCKQUOTE></BODY></HTML>