[TinyOWS-dev] [tinyows] #40: sql request to Postgis generated by a GetFeature request returns an error

[Yewondwossen Assefa]

Norm,

  Check the thread here which mention this issue: 
http://lists.maptools.org/pipermail/tinyows-dev/2009-April/000103.html

  if you are using 1.3.x version, you could do the following patch until 
we upgrade to 1.4:

--- wfs_get_feature.c   (revision 132)
+++ wfs_get_feature.c   (working copy)
@@ -478,7 +478,8 @@
                  else
                      buffer_add_int(select, o->degree_precision);

-                buffer_add_str(select, ", 1) AS \"");
+                //buffer_add_str(select, ", 1) AS \"");
+                buffer_add_str(select, ") AS \"");
                  buffer_copy(select, an->key);
                  buffer_add_str(select, "\" ");
              }

Hope it helps.

Best Regards,

Normand Savard wrote:
> Olivier Courtin wrote:
>> Normand,
>>
>> First question, which PostGIS version do you use ?
>> I think it's still a 1.3.x isn'it ?
>>
>> Also note that default meter precision could be set directly from config.xml
>> file (in tinyows element)
>>
>>   
> Yes Postgis 1.3.5.  Isn't it a recent version:  
> http://postgis.refractions.net/download/.  Postgis 1.4 isn't out yet :-)
> 
> =-O   You're right.  Hmmm!  Didn't see it.  To what is it set in other 
> Postgis version?  Could the default be one? :-)
> 
> Norm
> _______________________________________________
> TinyOWS-dev mailing list
> TinyOWS-dev at lists.maptools.org
> http://lists.maptools.org/mailman/listinfo/tinyows-dev
> 


-- 
----------------------------------------------------------------
Assefa Yewondwossen
Software Analyst

Email: assefa at dmsolutions.ca
http://www.dmsolutions.ca/

Phone: (613) 565-5056 (ext 14)
Fax:   (613) 565-0925
----------------------------------------------------------------