<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
</head>
<body class='hmmessage'>
Hi Ge,<br><br>You may want to check Probe_Geometry_Columns (http://postgis.refractions.net/docs/Probe_Geometry_Columns.html).<br><br>Kind regards,<br><br>Edward<br><br><br><br><hr id="stopSpelling">Date: Wed, 18 May 2011 04:38:51 -0700<br>From: gves2000@yahoo.com<br>To: postgis-users@postgis.refractions.net<br>Subject: [postgis-users] how to keep geometry_columns in sync with tables and views<br><br><table border="0" cellpadding="0" cellspacing="0"><tbody><tr><td style="font: inherit;" valign="top">Hi All,<br><br>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 slow when an application has to do a table scan to obtain the geometry type.<br><br>What I like to have is a procedure which checks all tables and views against the geometry_columns table and makes if necessary the right corrections.<br><br>Before inventing the wheel again, does anyone know if this procedure already exist or knows perhaps another/better way to achieve this? <br><br>Thanks in advance,<br><br>Ge<br><br><br><br><br></td></tr></tbody></table><br>_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users </body>
</html>