[postgis-users] adding columns to the geometry_columns table

George Rodrigues da Cunha Silva georger.silva at gmail.com
Mon Jul 25 06:15:40 PDT 2011


Em segunda-feira, 25 de julho de 2011 05:51:16, Jan Hartmann escreveu:
> Hi,
> 
> When I create a table "like" another table with geometry columns, the 
> the public.geometry_columns table is not updated. The 
> "probe_geometry_columns()" and "populate_geometry_columns" functions 
> don't work on the new table, because they cannot determine the srid of 
> the geometry column in the new, empty table. Is there another way to 
> update the geometry_columns table? Alternatively, would it make sense to 
> add a "srid"-parameter to "probe_geometry_columns()" and 
> "populate_geometry_columns()"?
> 
> Jan
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

You can just add it yourself?

If you are working programatically, you can look up the catalog and 
find out what is the geometry srid constraint for that table.

George

-- 
-------------------
-------------
George Rodrigues da Cunha Silva
Desenvolvedor GIS
http://geoprocessamento.net
http://blog.geoprocessamento.net



More information about the postgis-users mailing list