[postgis-users] update Geometry_columns
Mark.Fenbers at noaa.gov
Thu Jun 16 10:07:16 PDT 2005
By "constraints" do you mean that it can be any type constraint, such as
a foreign-key constraint? Or does it have to be a unique identifier
constraint? If so, I can ALTER TABLE ADD COLUMN and add such a
constraint, but I don't know what to use for the naming convention used
by AddGeometryColumns() and probe_geometry_columns() that you speak
of... Can you help me out. please?
strk at refractions.net wrote:
>probe_geometry_columns() works by reading constraints, and
>expects these constraints to have a given naming convention.
>This is what happen when AddGeometryColumn() is invoked.
>When you need to move data from a table to another
>you have to make AddGeometryColumn() part of your flow,
>or manually add entries in the geometry_columns table,
>or - finally - set up constraints named as the ones created
>by AddGeometryColumn() and invoke probe_geometry_column().
>postgis-users mailing list
>postgis-users at postgis.refractions.net
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 283 bytes
Desc: not available
More information about the postgis-users