[fdo-trac] #394: PostGIS Defect : Describe schema fails when advanced types present

[FDO]

#394: PostGIS Defect : Describe schema fails when advanced types present
--------------------------------+-------------------------------------------
   Reporter:  mwtoews           |       Owner:  mloskot
       Type:  defect            |      Status:  new    
   Priority:  major             |   Milestone:         
  Component:  PostGIS Provider  |     Version:  3.2.3  
   Severity:  2                 |    Keywords:         
External_id:                    |  
--------------------------------+-------------------------------------------
 I've successfully added/edited spatial data in AutoCAD Map 3D 2008 using a
 PostgreSQL schema where the columns use basic types (integer, character
 varying, etc.).

 However, if I add a column to a table in that schema (spatial or not) with
 an advanced type, such as text[], integer[], or timestamp with time zone,
 the describe schema fails completely and I cannot add or use anything. My
 error are (e.g.):
  * The '_int4' data type is not supported by PostGIS provider.
  * The 'timestamptz' data type is not supported by PostGIS provider.

 I define custom types as well (such as enums), but I dread to attempt
 anything more with the current situation.

 For "not supported" types, the data should be cast to text for FDO use
 (like ODBC), and and cast back from text to original type on
 insert/update.

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