Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I imported shp to postgis 2.0.1 with shp2pgsql and chose to use geography instead of geometry. However, now when I try to drop the table, the pgadmin/sql console/phpPgAdmin freezes. I can't neither truncate it or change the columns.

Any help would be appreciated :-).

share|improve this question
    
try "drop table tablename cascade;" from query window –  simplexio Dec 5 '12 at 13:49
    
Tried before, doesn't work. –  zimmi Dec 5 '12 at 13:51
    
Try to VACUUM ... Can you operates the data? ( select, update, and so ... ) –  Magno C Dec 5 '12 at 13:58
    
Can you login into the database using psql? –  djq Dec 5 '12 at 15:15
    
At this point i would login to Freenode and #postgresql or #postgis and ask it there. –  simplexio Dec 10 '12 at 13:47
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.