[postgis-users] guestion about geometry_columns in PostgreSQL 8.2

[Obe, Regina]

I'm not sure if this function still exists in newer postgis or if I just
inherited it from an older version upgraded.  I couldn't find it listed
in the newer manual aside from in the appendix.

There is a function called probe_geometry_columns() which you can use to
rebuild your geometry_columns table.  You should use it with caution
though since it will not inspect views etc.  sometimes I manually add
entries into geometry_columns to account for my views that have
geometries.

Anyrate what I usually do when I have used it is the following

First backup my original geometry_columns table with
select * into geometry_columns_backup from geometry_columns

Then I delete all the rows in my geometry_columns table with
delete from geometry_columns

Then I run probe_geometry_columns like

SELECT probe_geometry_columns()


----
If you don't delete rows first from geometry_columns,  I believe that
the probe_geometry_colums() will only add records not delete them.

Hope this helps,
Regina

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Maciej Skorczewski
Sent: Monday, February 26, 2007 8:16 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] guestion about geometry_columns in
PostgreSQL 8.2

ok but i what just delete 3-4 rows in geometry_columns table.

I use 3 postgis table and geometry_columns table have about 10 row (this

are table who was add earlier then dalete)


i use pgAdmin - and after delate 1 row , when i reload table it is agin 
there.

silmpe delete * from geometry_columns where srid=xxx

maciek
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

-----------------------------------------
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.