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) The postgis functions I know of that update that table are the following: AddGeometryColumn() -- which creates a new geometry field in a table DropGeometryColumn() - which drops a geometry field that was created with ST_AddGeometryColumn probe_geometry_columns() - which adds new entries from tables that have the respective check constraints created by AddGeometryColumn (or by hand) UpdateGeometrySRID() - which updates all the SRIDS in a table geometry column and also corrects the geometry_columns() table. 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. Hope that helps, Regina
________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sarel Coetzer Sent: Tuesday, July 01, 2008 6:50 AM To: postgis-users@postgis.refractions.net Subject: [postgis-users] geometry_columns table Hi 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. I require this table (geometry_columns) to be updated every time the Postgis DB is edited, can anyone help please? How is this table created? With which table does it have a relationship with? How can I update this table to current PostGIS layers? Thanks for your help in advance Regards Sarel -- "http://sarelgis.blogspot.com/"; ----------------------------------------- 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.
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
