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 <[email protected]>
>To: [email protected]
>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
>[email protected]
>http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
