[QGIS-trac] Re: [Quantum GIS] #1087: adding postgis data with geometry field based on a domain and not a simple geometry type

[Quantum GIS]

#1087: adding postgis data with geometry field based on a domain and not a simple
geometry type
-----------------------------------------------------+----------------------
        Reporter:  zawardo                           |         Owner:  jef           
            Type:  defect                            |        Status:  new           
        Priority:  major: does not work as expected  |     Milestone:                
       Component:  Data Provider                     |       Version:                
      Resolution:                                    |      Keywords:  postgis domain
Platform_version:  0.10                              |      Platform:  Windows       
        Must_fix:  No                                |   Status_info:  1             
-----------------------------------------------------+----------------------
Comment (by zawardo):

 Replying to [comment:1 jef]:
 > Could you provide a SQL script to create your table?

 of course:

 CREATE DOMAIN check_prova1
   AS geometry
    CONSTRAINT essere_2d CHECK ((dimension(VALUE) = 0)) CONSTRAINT
 proiezione CHECK ((srid(VALUE) = 668)) CONSTRAINT essere_punto CHECK
 ((geometrytype(VALUE) = 'POINT'::text));

 CREATE TABLE test
 (
   id integer,
   the_geom check_prova1
 )
 WITH (OIDS=FALSE);

 However i just noticed that manually adding che table into the geometry
 _columns table, makes it visible into the qgis environment:)

 It still would be fine if it was recognized even if not present in the
 geometry _columns (like other tables with simple geometry type).

 Thank you!

-- 
Ticket URL: <https://trac.osgeo.org/qgis/ticket/1087#comment:2>
Quantum GIS <http://qgis.org>
Quantum GIS is an Open Source GIS viewer/editor supporting OGR, PostGIS, and GRASS formats