[postgis-users] update Geometry_columns

[Mark Fenbers]

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().
>
>--strk;
>_______________________________________________
>postgis-users mailing list
>postgis-users at postgis.refractions.net
>http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>  
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Mark.Fenbers.vcf
Type: text/x-vcard
Size: 283 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20050616/5ca789b0/attachment.vcf>