[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                 |    Keywords:         
External_id:                    |  
--------------------------------+-------------------------------------------
 The code sample from FDO Developer’s Guide, Inserting Values, Page 92
 fails with the PostGIS FDO provider.

 The provider writes to the command line:

 `NOTICE:  identifier "a400000000000003240000`
 `00000008050400000000000003740000000000040524000000000000022400000000000004840000`
 `00000000018400000000000004a400000000000003240050000000000000000804d4000000000000`
 `032400000000000c0504000000000000032400000000000c050400000000000002a4000000000008`
 `04d400000000000002a400000000000804d400000000000003240" will be truncated
 to "a40`
 `000000000000324000000000008050400000000000003740000000000040"`
 `*** FDO Error:   *** The execution of SQL statement failed with
 PostgreSQL error`
 `code: PGRES_FATAL_ERROR, ERROR:  syntax error at or near
 "A40000000000000324000`
 `00000000805040000000000000374000000000004052400000000000002240000000000000484000`
 `000000000018400000000000004A400000000000003240050000000000000000804D400000000000`
 `0032400000000000C0504000000000000032400000000000C050400000000000002A400000000000`
 `804D400000000000002A400000000000804D400000000000003240"`
 `LINE 1: ...Blue
 Lake',010300000002000000050000000000000000004A400000000...`
 `                                                             ^`

 If the line in the sample that adds the geometry property to the value
 collection is removed, the insert succeeds.

 `FdoInt32 valueCollectionIndex =
 values->Add(sampleGeometryPropertyValue);`

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