[postgis-users] Incorrect geometry_columns?

[Paolo Cavallini]

Il 09/12/2012 16:21, Francois Hugues ha scritto:
> As I can see in the view definition, srid comes from postgis constraint : COALESCE(NULLIF(postgis_typmod_srid(a.atttypmod), 0), postgis_constraint_srid(n.nspname::text, c.relname::text, a.attname::text), 0) AS srid, 
> 
> Did you have / did you try to add this kind of constraint on your table :
> 
> CONSTRAINT enforce_srid_geom CHECK (st_srid(geom) = 3003) ?

Hi all.
More info: the lack of SRID and geometry type in the geometry_columns happens only
for the tables created by PostGIS functions (e.g. st_union, st_convexhull, etc.).
Is this a known issue?
All the best.
-- 
Paolo Cavallini - Faunalia
www.faunalia.eu
Full contact details at www.faunalia.eu/pc
Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario