[postgis-devel] Geometry Columns View

[maplabs at light42.com]

What makes some tables show their geometry type as GEOMETRY while 
others are POINT or MULTIPOLYGON, etc ?

to wit -

 geocoder_ca     | public         | 
geocoder_test_out_post_spatial | the_geom          
|               2 |    0 | GEOMETRY
 geocoder_ca     | public         | 
parcels_alameda_2010_4326      | the_geom          
|               2 |    0 | GEOMETRY
 geocoder_ca     | public         | 
parcels_alameda_addrs_2010     | the_geom          
|               2 |    0 | GEOMETRY
 geocoder_ca     | public         | 
some_yahoo                     | 
the_geom          |               2 |    0 | 
GEOMETRY
 geocoder_ca     | tiger          | 
county                         | 
the_geom          |               2 | 4269 | 
MULTIPOLYGON
 geocoder_ca     | tiger          | 
cousub                         | 
the_geom          |               2 | 4269 | 
MULTIPOLYGON
 geocoder_ca     | tiger          | 
edges                          | 
the_geom          |               2 | 4269 | 
MULTILINESTRING
 geocoder_ca     | tiger          | 
faces                          | 
the_geom          |               2 | 4269 | 
MULTIPOLYGON
 geocoder_ca     | tiger          | 
place                          | 
the_geom          |               2 | 4269 | 
MULTIPOLYGON
 geocoder_ca     | tiger          | 
state                          | 
the_geom          |               2 | 4269 | 
MULTIPOLYGON
 geocoder_ca     | tiger          | 
zcta5                          | 
the_geom          |               2 | 4269 | 
MULTIPOLYGON
 geocoder_ca     | tiger          | 
zcta500                        | 
the_geom          |               2 | 4269 | 
MULTIPOLYGON
 geocoder_ca     | tiger_data     | 
ca_county                      | 
the_geom          |               2 | 4269 | 
MULTIPOLYGON

--------------

the first four tables are actually - POINT, MULTIPOLYGON, MULTIPOLYGON, POINT

curiously,   executing        update some_yahoo set the_geom = 
st_setsrid( the_geom, 4326);
did nothing to either the SRID or GEOMTRY TYPE when reading 
geometry_columns VIEW again... 

==
Brian Hamlin
GeoCal
OSGeo California Chapter
415-717-4462 cell