Re: [postgis-users] how to keep geometry_columns in sync with tables and views

2011-05-18 Thread Ben Madin
t populate geometry columns so much as update the geometry_columns > table. > > But irrespective of the name, it is nice to have :-) > > > Cheers > > Brent Wood > > --- On Thu, 5/19/11, Ben Madin wrote: > > From: Ben Madin > Subject: Re: [postgis-u

Re: [postgis-users] how to keep geometry_columns in sync with tables and views

2011-05-18 Thread pcreso
Mac Gillavry Subject: Re: [postgis-users] how to keep geometry_columns in sync with tables and views To: postgis-users@postgis.refractions.net Date: Wednesday, May 18, 2011, 4:57 AM Hi Ge, You may want to check Probe_Geometry_Columns (http://postgis.refractions.net/docs/Probe_Geometry_Columns.html

Re: [postgis-users] how to keep geometry_columns in sync with tables and views

2011-05-18 Thread Ben Madin
not work because this function doesn't do anything with views. Also > stale records aren't removed. > > Ge > > --- On Wed, 5/18/11, Edward Mac Gillavry wrote: > > From: Edward Mac Gillavry > Subject: Re: [postgis-users] how to keep geometry_columns in sync w

Re: [postgis-users] how to keep geometry_columns in sync with tables and views

2011-05-18 Thread G. van Es
Hi Edward, This will not work because this function doesn't do anything with views. Also stale records aren't removed. Ge --- On Wed, 5/18/11, Edward Mac Gillavry wrote: From: Edward Mac Gillavry Subject: Re: [postgis-users] how to keep geometry_columns in sync with tables an

Re: [postgis-users] how to keep geometry_columns in sync with tables and views

2011-05-18 Thread Edward Mac Gillavry
geometry_columns in sync with tables and views Hi All, We have a lot of tables and views updated, or better said, replaced on a daily basis. We have seen that under certain conditions (which are unclear) entries of the geometry_columns table are removed. So a mismatch occurs so now and then

[postgis-users] how to keep geometry_columns in sync with tables and views

2011-05-18 Thread G. van Es
Hi All, We have a lot of tables and views updated, or better said, replaced on a daily basis. We have seen that under certain conditions (which are unclear) entries of the geometry_columns table are removed. So a mismatch occurs so now and then resulting in showing either no data or being very