Tell me more ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.
up vote 0 down vote favorite

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

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

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.