[postgis-users] DropGeometryColumn

[Benjamin Wragg]

When I get this I just do the following:

Delete from geometry_columns where f_table_name like
'Name_Of_Spatial_Table_Deleted';

Cheers,

Benjamin Wragg

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Jan
Hartmann
Sent: Friday, 19 March 2004 4:12 AM
To: PostGIS Users Discussion
Subject: [postgis-users] DropGeometryColumn


I don't know if I diagnosed this problem correctly, but I regularly 
stumble over the following situation:


I create a spatial table, and delete it after some time. When I create a

new spatial table under the same name, I get an error message about 
"duplicate geometry column names". It seems that before deleting a 
spatial table, you *have* to drop manually the geometry column of that 
table with DropGeometryColumn(). I don't know how to remove this column 
after deleting the table, so this leaves me with a database where I 
cannot create tables that have been deleted the wrong way.

Am I right that this is how it works? If so, could it be remedied, e.g. 
by some sort of trigger on dropping a spatial table?

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