[postgis-devel] [PostGIS] #1194: geometry_column wrong to establish the geometrytype in some views

[PostGIS]

#1194: geometry_column wrong to establish the geometrytype in some views
-----------------------+----------------------------------------------------
 Reporter:  aperi2007  |       Owner:  pramsey      
     Type:  defect     |      Status:  new          
 Priority:  medium     |   Milestone:  PostGIS 2.0.0
Component:  postgis    |     Version:  trunk        
 Keywords:             |  
-----------------------+----------------------------------------------------

Comment(by robe):

 Andrea,

 Unfortunately I fear that is one of those gotchas which I'll be explaining
 in the FOSS4G talk we are giving.  When you apply a postgis function,
 there is no way for PostgreSLQ to know the geometry output type since our
 functions just return a goemetry.

 The work around is to cast it.

 Can you try that and see if it makes a difference?

 on both

 ST_Force_3D(b.geom)::geometry(POLYGONZ,yoursridhere)

 Do that for both parts of your union all.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1194#comment:1>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.