[postgis-users] usage of AddGeometryColumn etc.

[strk]

On Thu, Jun 03, 2004 at 04:42:53PM +0200, Markus Schaber wrote:
> Hi,
> 
> On Thu, 3 Jun 2004 00:01:05 +0200
> strk <strk at keybit.net> wrote:
> 
> > FYI, Cleanup will currently (CVS) be done by:
> > 	AddGeometryColumn()
> > 	fix_geometry_columns()
> > 	update_geometry_stats()
> > 
> > These functions will remove stale records.
> 
> Great!
> 
> Do they emit a info / warning when such records were found?

fix_geometry_columns(), update_geometry_stats() and
update_goemetry_stats(table, geomcolumn) will print a short
report of their activity.

AddGeometryColumn(...) will 'eat' output of fix_geometry_columns()
and eventual deletion of a pre-existing interfeering record.

WARNING: malformed records in geometry_columns will be deleted!
         This are records for which f_table_schema is the incorrect
         schema. Since unexistant or empty or null schemas in
         f_table_schema will be tranformed to 'public' these might
         also end up getting the incorrect value.

--strk;

> 
> Thanks,
> markus
> 
> 
> 
> -- 
> markus schaber | dipl. informatiker
> logi-track ag | rennweg 14-16 | ch 8001 zürich
> phone +41-43-888 62 52 | fax +41-43-888 62 53
> mailto:schabios at logi-track.com | www.logi-track.com
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users