[fdo-trac] #104: PostGIS provider cannot insert features with geometry

[FDO]

#104: PostGIS provider cannot insert features with geometry
------------------------------+---------------------------------------------
 Reporter:  cwilbur           |         Owner:  mloskot
     Type:  defect            |        Status:  new    
 Priority:  major             |     Milestone:  3.3.0  
Component:  PostGIS Provider  |       Version:  3.2.0  
 Severity:  3                 |    Resolution:         
 Keywords:                    |   External_id:         
------------------------------+---------------------------------------------
Comment (by jbirch):

 I've spoken with Paul about this a bit...

 If you are using WKT with PostgreSQL, then it will limit you to two
 dimensions.

 I'm not convinced that this is the correct approach to the problem.  To
 me, this email

 http://www.nabble.com/Defects-in-PostGIS-provider-
 tf4313206s18162.html#a12282593

 would indicate that the reason the insert is failing is because the hexwkb
 value is not being quoted.  I believe that PostgreSQL is trying its best
 to detect the unquoted value as a number (the only thing that is allowed
 to be not quoted), and then interpreting the rest of the value as a column
 identifier (odd, but...).

 Is there any way to add quotes to the built query?  All values (even
 numbers) are allowed to be quoted in PostgreSQL.

-- 
Ticket URL: <http://trac.osgeo.org/fdo/ticket/104#comment:9>
FDO <http://fdo.osgeo.org/>
Feature Data Objects