<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16481" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=366475410-01072008><FONT face=Arial
color=#0000ff size=2>Those tables are only modified by PostGIS using the
following functions or by direct user intervention (yes you can modify it
directly and I do when I'm creating views since there is currently no way to
make the table add a view)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=366475410-01072008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=366475410-01072008><FONT face=Arial
color=#0000ff size=2>The postgis functions I know of that update that table are
the following:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=366475410-01072008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=366475410-01072008><FONT face=Arial
color=#0000ff size=2>AddGeometryColumn() -- which creates a new geometry
field in a table</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=366475410-01072008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=366475410-01072008><FONT face=Arial
color=#0000ff size=2>DropGeometryColumn() - which drops a geometry field that
was created with ST_AddGeometryColumn</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=366475410-01072008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=366475410-01072008><FONT face=Arial
color=#0000ff size=2>probe_geometry_columns() - which adds new entries from
tables that have the respective check constraints created by AddGeometryColumn
(or by hand)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=366475410-01072008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=366475410-01072008><FONT face=Arial
color=#0000ff size=2>UpdateGeometrySRID() - which updates all the SRIDS in
a table geometry column and also corrects the geometry_columns()
table.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=366475410-01072008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=366475410-01072008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=366475410-01072008><FONT face=Arial
color=#0000ff size=2>The plan in the future is to make geometry_columns a view
which reads from the PostgreSQL system catalogs. When that is done, then
it will behave as you are expecting it to.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=366475410-01072008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=366475410-01072008><FONT face=Arial
color=#0000ff size=2>Hope that helps,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=366475410-01072008><FONT face=Arial
color=#0000ff size=2>Regina</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=366475410-01072008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of </B>Sarel
Coetzer<BR><B>Sent:</B> Tuesday, July 01, 2008 6:50 AM<BR><B>To:</B>
postgis-users@postgis.refractions.net<BR><B>Subject:</B> [postgis-users]
geometry_columns table<BR></FONT><BR></DIV>
<DIV></DIV>Hi<BR><BR><BR>I have searched the forum but am still confused about
the geometry_columns table. Importing and deleting PostGIS layers doesn't seem
to have an effect on the geometry_columns table, very strange as this is a GIS
catalog to the spatial database.<BR><BR>I require this table (geometry_columns)
to be updated every time the Postgis DB is edited, can anyone help
please?<BR><BR>How is this table created?<BR>With which table does it have a
relationship with?<BR>How can I update this table to current PostGIS
layers?<BR><BR>Thanks for your help in advance<BR><BR><BR>Regards<BR>Sarel<BR
clear=all><BR>-- <BR>"<A
href="http://sarelgis.blogspot.com/">http://sarelgis.blogspot.com/</A>"
</BODY></HTML>
<HTML><BODY><P><hr size=1></P>
<P><STRONG>
The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer.
</STRONG></P></BODY></HTML>
<P><hr size=1></P>
<P><STRONG><font size="2" color="339900"> Help make the earth a greener place. If at all possible resist printing this email and join us in saving paper. </p> <p> </font></STRONG></P>