[postgis-users] adding columns to the geometry_columns table

[Phil James]

I think this i because the constraints from the existing table (geom type and srid) are not copied over with the data.   You need to recreate these (copy them from the CREATE TABLE sql from the "old" table).  probe_geometry_columns() will then do what it is supposed to do.

Phil



>________________________________
>From: Jan Hartmann <j.l.h.hartmann at uva.nl>
>To: postgis-users at postgis.refractions.net
>Sent: Monday, 25 July 2011, 9:51
>Subject: [postgis-users] adding columns to the geometry_columns table
>
>
>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
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110725/22502f95/attachment.html>