[postgis-users] create a dataset with a name I already used before

[strk at refractions.net]

On Fri, Sep 23, 2005 at 01:36:38PM +0400, david techer wrote:
> Hi
> 
> select dropgeometrytable('your_table','geom_column')
> 
> before
> 
> drop table your_table
> 
> I'm not sure...
> 
> perhaps Sandro can tell me if I'm right or not

The DropGeometryTable() will take care of dropping the
table, you don't need to explicitly do it.

Anyway, if you drop the table directly a reference
to it will still be in the geometry_columns table,
you have to delete it if you want to successfully
call AddGeometryColumn again with the same schema,table,column.

DELETE FROM geometry_columns WHERE .....

--strk;

> 
> -------------------------------------------------
> Jean David TECHER
> 01MAP
> 35 Allée d'Irlande
> 34080 Montpellier
> France
> Tél: 04 67 45 60 27
> e-mail: davidtecher(at)yahoo(dot)fr
> sites: http://www.postgis.fr
>       http://techer.pascal.free.fr/postgis/
> -------------------------------------------------
> 
> 
> 
> Giorgio Plazzotta a écrit :
> 
> >I apologize if the problem i am reporting has already been treated 
> >before. When I delete a table in the PG database maybe there is some 
> >reference that continue to refer to that name, in fact I cannot use 
> >that table name anymore when I create another dataset.
> >What do I have to do?
> >
> >Giorgio
> >_______________________________________________
> >postgis-users mailing list
> >postgis-users at postgis.refractions.net
> >http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> 
> 	
> 
> 	
> 		
> ___________________________________________________________________________ 
> Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger 
> Téléchargez cette version sur http://fr.messenger.yahoo.com
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users