[postgis-devel] SRID and type constraints

[strk]

I've update AddGeometryColumn() to name type and srid
checks as 'enforce_geotype' and 'enforce_srid'.

--strk;

On Fri, Jun 04, 2004 at 03:47:36PM +0200, strk wrote:
> 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
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel