[postgis-devel] SRID and type constraints

[strk]

Ok. I've modified fix_geometry_columns() and probe_geometry_columns()
to not rely on constraint name by using a LIKE expression on
consrc instead.

Also, I've aded a rename_geometry_table_constraint() function
for the braves ... it will use 'enforce_srid' and 'enforce_geotype'
Note that the other function will now work anyway, so this is
for future expansions...

--strk;


On Fri, Jun 04, 2004 at 03:02:54PM +0200, strk wrote:
> The new fix_geometry_columns() and probe_geometry_columns()
> make use of geometry constraints on SRID and TYPE applyed
> to spatially enabled tables.
> 
> These checks, enforced by AddGeometryColumns are currently
> anonimous so they gets a name in the form '$#'.
> If the table does not have any anonimous constraint these
> will be $1 for srid and $2 for type check, but we cannot 
> safely rely on this to be the case.
> 
> My proposal is to give a meaningful name to the checks, like
> 'enforce_srid' for srid check and 'enforce_geotype' for type check.
> We should also rename all existing checks for this to work,
> which might be done automatically by fix_geometry_columns() and
> probe_geometry_columns().
> 
> Comments ?
> 
> --strk;
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel